Data types

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