To display a list of default data types, choose Options | Data types from the Scriptoria main menu.
The following form shows initial data type settings. The data type values are applied to all tables that are converted to SQL Server.
When creating SQL Server table columns, equivalent SQL Server data types are substituted for Access types. You can specify global defaults for each type, and optionally assign different types for individual table columns. Global types are substituted whenever a column has not been individually assigned a data type.
|
Access Data Types |
Equivalent SQL Server Data Types
|
|
|
|
|
Yes/No |
bit |
|
Byte |
tinyint |
|
Integer |
Defaults to smallint; Alternative combo-box entry is int. |
|
Long |
Defaults to int; Alternative combo-box entries are bigint and smallint. |
|
Currency |
Defaults to smallmoney. Alternative combo-box entries are money and decimal. |
|
Single |
Defaults to real; Alternative combo-box entry is float. |
|
Double |
Defaults to float; Alternative combo-box entry is real. |
|
Date |
Defaults to datetime; The alternative combo-box entry smalldatetime. |
|
Binary |
Defaults to binary; Alternative combo-box entry is varbinary. |
|
Text |
Defaults to nvarchar; Alternative combo-box entries are char, nchar and varchar. The length of the MS-Access field is set to the value specified in the data type definition, e.g. nvarchar(50)). |
|
OLE Object |
image (see Note-1) |
|
Memo |
text (see Note-1) |
|
AutoNumber |
Defaults to int; Alternative combo-box entries are bigint, decimal and smallint. |
Note-1: Although MS-SQL 2005 recommends image types be replaced by varbinary(max) and text by varchar(max), as of this writing (Jan. 2007) ODBC will not operate properly unless image and text types are used.