|
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 |
