ASE server data type mappings

Data type in ASE

Data type in C# models

Data type returned by PowerServer on SyntaxFromSQL

bigdatetime

DateTime

 

bigint

decimal

Decimal(0)

bigtime

DateTime

datetime

binary

byte[]

char

bit

bool

number(1)

char

string

char

date

DateTime

date

datetime

DateTime

datetime

decimal

decimal

decimal

float

double

number

image

 

blob

int

int

long

longsysname

string

char

money

decimal

decimal

nchar

string

char

numberic

decimal

decimal

nvarchar

string

char

real

float

real

smalldatetime

DateTime

datetime

smallint

short

long

smallmoney

decimal

decimal

sysname

string

char

text

string

char

time

TimeSpan

time

timestamp

byte[]

timestamp

tinyint

byte

long

unichar

string

char

unitext

string

char

univarchar

string

char

unsigned bigint

decimal

decimal

usigned int

long

ulong

unsigned smallint

int

ulong

varbinary

byte

char

varchar

string

char