Client Data Types | Microsoft SQL Server Data Types |
|---|---|
BIGINT | BIGINT |
BYTE VARYING(n) | Not Supported |
BYTE(n)* | Not Supported |
C | Not Supported |
CHAR(n) Note: CHARACTER(n) is a synonym for CHAR(n). | CHAR(n) Note: The length specifier (n) is required in DDL statements. |
DATE | DATETIME |
DECIMAL(p,s)* | Note: DECIMAL(p,s)* If you select the money mapping for Microsoft SQL Server, all data declared as DECIMAL(19,4), DECIMAL(10,4), MONEY and SMALLMONEY is returned as OpenSQL Money data type. |
DECIMAL(19,4) | Note: MONEY-Money data type mapping If you select the money mapping for Microsoft SQL Server, all data declared as DECIMAL(19,4), DECIMAL(10,4), MONEY and SMALLMONEY is returned as OpenSQL Money data type. |
DECIMAL(10,4) | Note: MONEY-Money data type mapping If you select the money mapping for Microsoft SQL Server, all data declared as DECIMAL(19,4), DECIMAL(10,4), MONEY and SMALLMONEY is returned as OpenSQL Money data type. |
FLOAT | FLOAT |
FLOAT4 | REAL |
FLOAT8 | FLOAT |
INTEGER | INTEGER |
INTEGER1/TINYINT | TINYINT—Range from 0 to +127. This range is a subset of the MS SQL data type TINYINT range (0 to +255) and the OpenSQL data type INT1 range (-128 to +127). Microsoft SQL does not issue an error if the parameter is greater than 127 and less than 256. Values greater than 127 are returned as negative numbers (in twos complement). |
INTEGER2 | SMALLINT |
INTEGER4 | INTEGER |
LONG BYTE* | VARBINARY(MAX), where MAX is the maximum storage size of 2^31 – 1 characters The IMAGE type will be deprecated in a future version of Microsoft SQL Server. |
LONG NVARCHAR | NVARCHAR(MAX), where MAX is the maximum storage size of 2^31 – 1 characters The NTEXT type will be deprecated in a future version of Microsoft SQL Server. |
LONG VARCHAR* | VARCHAR(MAX), where MAX is the maximum storage size of 2^31 – 1 characters The TEXT type will be deprecated in a future version of Microsoft SQL Server. |
MONEY | Note: FLOAT—Default money data type mapping MONEY—Money data type mapping If you select the money mapping for Microsoft SQL Server, all data declared as DECIMAL(19,4), DECIMAL(10,4), MONEY and SMALLMONEY is returned as OpenSQL Money data type. |
NCHAR(n) | NCHAR(n)—Maximum size of n is 4,000. Storage size is two times n bytes. The length specifier (n) is required in DDL statements. |
NVARCHAR(n) | NVARCHAR(n)—Maximum size of n is 4,000. Storage size is two times n bytes. The length specifier (n) is required in DDL statements. |
REAL | REAL |
SMALLINT | SMALLINT |
TEXT | Not Supported |
VARCHAR(n) | VARCHAR(n) Note: Notes: • The length specifier (n) is required in DDL statements. • If n is >8000, it will be truncated to 8000. |