|
Data type in Oracle |
Data type in C# models |
Data type returned by PowerServer on SyntaxFromSQL |
|
BINARY_DOUBLE |
double |
BinaryDouble |
|
BINARY_FLOAT |
single |
BinaryFloat |
|
BLOB |
Blob |
|
|
CLOB |
string |
Char |
|
CHAR |
string |
Char |
|
DATE |
datetime |
Datetime |
|
INTERVAL DAY(2) TO SECOND(6) |
||
|
INTERVAL YEAR(2) TO MONTH |
||
|
LONG |
string |
Char |
|
NCLOB |
string |
Char |
|
NVARCHAR2 |
string |
Char |
|
RAW |
Blob |
|
|
TIMESTAMP(6) |
datetime |
Datetime |
|
TIMESTAMP(6) WITH LOCAL TIME ZONE |
datetime |
Datetime |
|
TIMESTAMP(6) WITH TIME ZONE |
datetime |
Datetime |
|
VARCHAR2 |
string |
char |
|
NUMBER(2) |
short |
int16 |
|
number |
Decimal |
|
|
NUMBER(5,2) |
single |
Single |
|
number(10) |
Int64 |
|
|
number(10,2) |
double |
|
|
number(7) |
int32 |
|
|
number(15) |
int64 |
