This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
integration:rdbms:sqlserver:datatypes [2011/04/08 04:14] doc |
integration:rdbms:sqlserver:datatypes [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| | CHAR | CHAR(ACTER) | | | | CHAR | CHAR(ACTER) | | | ||
| | VARCHAR | STRING or VARCHAR | Favor STRING unless your character data cannot be terminated by a NULL character. | | | VARCHAR | STRING or VARCHAR | Favor STRING unless your character data cannot be terminated by a NULL character. | | ||
| - | | NCHAR | NATIONAL CHAR(ACTER) | Omnidex has limited support for Unicode datatpes, but recommends the use of CHARACTER datatype. | | + | | NCHAR | NATIONAL CHAR(ACTER) | Omnidex has limited support for Unicode datatypes, but recommends the use of CHARACTER datatype. | |
| - | | NVARCHAR | NATIONAL VARCHAR | Omnidex has limited support for Unicode datatpes, but recommends the use of STRING datatype. | | + | | NVARCHAR | NATIONAL VARCHAR | Omnidex has limited support for Unicode datatypes, but recommends the use of STRING datatype. | |
| | BIT | TINYINT | | | | BIT | TINYINT | | | ||
| | TINYINT | TINYINT | | | | TINYINT | TINYINT | | | ||