SQL Anywhere server data type mappings

Data type in SQL Anywhere

Data type in C# models

Data type returned by PowerServer on SyntaxFromSQL

bigint

long

decimal(0)

binary

 

blob

bit

bool

number

char

string

char

date

datetime

date

datetime

datetime

datetime

datetimeoffset

string

char

decimal(18,2)

decimal

decimal(2)

double

double

number

float

single

real

image

 

blob

integer

int

long

long binary

 

blob

long nvarchar

string

char

long varbit

string

char

long varchar

string

char

money

decimal

decimal

nchar

string

char

ntext

string

char

numeric(18,2)

decimal

decimal(2)

nvarchar

string

char

real

single

real

smalldatetime

datetime

datetime

smallint

short

long

smallmoney

decimal

decimal

text

string

char

time

timespan

time

timestamp

datetime

datetime

timestamp with time zone

string

char

tinyint

byte

long

uniqueidentifier

guid

char

uniqueidentifierstr

string

char

unsignedbigint

decimal

decimal

unsignedint

long

UnsingedLong

unsignedsmallint

int

UnsingedLong

varbinary(50)

 

blob

varbit(50)

string

char

varchar(50)

string

char

xml

string

char

sysname

string

char