The supported OpenDB data types when using a Microsoft SQL Server database are described below.
| SQL Server Data Type | Supported by OpenDB | Comments |
|---|---|---|
| binary | No | Uses ODBC data type sql_binary. |
| bit | Yes | |
| char | Yes | |
| datetime | Yes | |
| float | Yes | |
| image | No | Uses ODBC data type sql_binary. |
| int | Yes | |
| money | Yes | |
| nchar | Yes | |
| ntext | Yes | Only first 4K of characters display. |
| numeric | Yes | |
| nvarchar | Yes | |
| real | Yes | |
| smalldatetime | Yes | Requires OpenDB 3.4.2 or later. |
| smallint | Yes | |
| smallmoney | Yes | |
| text | Yes | Only the first 4K of characters display. |
| timestamp | No |
|
| tinyint | Yes | |
| uniqueidentifier | Yes | Requires OpenDB 3.4.3 or later. |
| varbinary | No | |
| varchar | Yes |