If you create or change columns, select the Data type from the respective drop-down list. Sizes and details can differ depending on the database system that you deploy. Please refer to the documentation of the database system for more information.
The following data types are available on the Microsoft SQL Server:
bigint
integer (big numbers)
binary
binary data with fixed length
bit
0 or 1 (true or false)
char
text with fixed length
datetime
date and time
decimal
packed-decimal format, exactly numeric
float
floating-point number
int
integer
money
floating point number
smallint
integer (small numbers)
tinyint
integer
varbinary
binary data, only for CAS partners
varchar
text with variable length
varchar(max)
text with variable length and any number of characters
nvvarchar
Unicode text with variable length, but a maximum of n characters
nvarchar(max)
Unicode text with variable length and any number of characters