When importing entities from the databases, OutSystems Platform maps SQL Server data types into OutSystems data types.

The map between the data types is specified in the following table:

SQL Server data Types

OutSystems data types

bigInt

Long Integer

binary

Binary Data

bit

Boolean

char

Text

date

Text

dateTime

Date Time

decimal

Decimal

float

Decimal

geography

Binary Data

image

Binary Data

int

Integer

money

Decimal

nchar

Text

ntext

Text

numeric

Integer

nvarchar

Text

real

Decimal

smalldatetime

Date Time

smallInt

Integer

smallmoney

Decimal

text

Text

time

Text

timestamp

Binary Data

tinyint

Integer

varbinary

Binary Data

varchar

Text

xml

Text

All other data types

Unsupported

See Also

Available Data Types | DB2 Data Types to OutSystems Data Types | MySQL Data Types to OutSystems Data Types | Oracle Data Types to OutSystems Data Types