Data Types
Table 3-2 lists the data types supported by the SQL Server driver and how they are mapped to the JDBC data types.
Table 3-2. SQL Server 2000 Data Types
| SQL Server Data Type |
JDBC Data Type |
| bigint |
BIGINT |
| bigint identity |
BIGINT |
| binary |
BINARY |
| bit |
BIT |
| char |
CHAR |
| datetime |
TIMESTAMP |
| decimal |
DECIMAL |
| decimal() identity |
DECIMAL |
| float |
FLOAT |
| image |
LONGVARBINARY |
| int |
INTEGER |
| int identity |
INTEGER |
| money |
DECIMAL |
| nchar |
CHAR |
| ntext |
LONGVARCHAR |
| numeric |
NUMERIC |
| numeric() identity |
NUMERIC |
| nvarchar |
VARCHAR |
| real |
REAL |
| smalldatetime |
TIMESTAMP |
| smallint |
SMALLINT |
| smallint identity |
SMALLINT |
| smallmoney |
DECIMAL |
| sql_variant |
VARCHAR |
| sysname |
VARCHAR |
| text |
LONGVARCHAR |
| timestamp |
BINARY |
| tinyint |
TINYINT |
| tinyint identity |
TINYINT |
| uniqueidentifier |
CHAR |
| varbinary |
VARBINARY |
| varchar |
VARCHAR |