diff options
| author | bar@bar.mysql.r18.ru <> | 2003-09-15 10:26:48 +0500 |
|---|---|---|
| committer | bar@bar.mysql.r18.ru <> | 2003-09-15 10:26:48 +0500 |
| commit | 1726b4d89e613806837cb2a3d8ee19ed37664c97 (patch) | |
| tree | 4862f70d6bf1d4769bb70053bf3b37f382776f99 /sql/lex.h | |
| parent | 6d62d31049377a7c886425552e14772d1416c34e (diff) | |
| download | mariadb-git-1726b4d89e613806837cb2a3d8ee19ed37664c97.tar.gz | |
New syntax:
CREATE TABLE t1(a NVARCHAR(10))
This is for compatibility with MSSQL, DB2, Informix and some other DBMSs.
Note, standard SQL doesn't have "NVARCHAR" syntax.
There are only these syntaxes in SQL2003:
NATIONAL VARCHAR
NCHAR VARCHAR
NATIONAL CHARACTER VARYING
NCHAR VARYING
- Tests were added for all the above syntaxes.
Diffstat (limited to 'sql/lex.h')
| -rw-r--r-- | sql/lex.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/lex.h b/sql/lex.h index fb3c018de42..e11b50ed16d 100644 --- a/sql/lex.h +++ b/sql/lex.h @@ -293,6 +293,7 @@ static SYMBOL symbols[] = { { "NOT", SYM(NOT),0,0}, { "NULL", SYM(NULL_SYM),0,0}, { "NUMERIC", SYM(NUMERIC_SYM),0,0}, + { "NVARCHAR", SYM(NVARCHAR_SYM),0,0}, { "OFFSET", SYM(OFFSET_SYM),0,0}, { "OLD_PASSWORD", SYM(OLD_PASSWORD),0,0}, { "ON", SYM(ON),0,0}, |