Supported
The supported database servers and data types are listed in the table below:
Table 202.
|
MS SQL Server |
Supported |
||
|
binary* |
bit |
bigint |
|
|
char |
datetime |
decimal |
|
|
float |
int |
image* |
|
|
money |
nchar |
numeric |
|
|
ntext |
nvarchar |
real |
|
|
small datetime |
small money |
smallint |
|
|
sql_variant |
text |
tinyint |
|
|
timestamp |
uniqueidentifier |
varbinary* |
|
|
varchar |
|||
|
You can only use the default value for the user_quoted_identifier property. |
|||
|
Unsupported |
|||
|
The data types that are marked with a "*" symbol can only be used in SELECTBLOB and UPDATEBLOB SQL statements. binary & varbinary On the Web, the data length of the two types can exceed 255 digits. Digits that exceed 255 can either be read from or updated to the database by SELECTBLOB or UPDATEBLOB statement. |
|||
|
SAP ASE Server |
Supported |
||
|
binary |
bit |
char |
|
|
date |
datetime |
decimal |
|
|
float |
Image |
int |
|
|
money |
nchar |
nvarchar |
|
|
numeric |
real |
smalldatetime |
|
|
smallint |
smallmoney |
text |
|
|
timestamp |
tinyint |
varbinary |
|
|
varchar |
|||
|
Unsupported |
|||
|
In a column, data of timestamp type cannot be displayed correctly. Timestamp data type is unsupported when dynamically creating DataWindows. |
|||
|
SAP ASA/SQL Anywhere Server |
Supported |
||
|
binary* |
bit |
bigint |
|
|
char |
date |
decimal |
|
|
double |
float |
integer |
|
|
long_binary* |
long_varchar |
money |
|
|
numeric |
smallint |
smallmoney |
|
|
time |
timestamp |
tinyint |
|
|
unsigned_bigint |
unsigned_int |
unsigned_smallint |
|
|
varbinary* |
varchar |
||
|
Unsupported |
|||
|
The data types that are marked with a "*" symbol can only be used in SELECTBLOB and UPDATEBLOB SQL statements. |
|||
|
Oracle Server |
Supported |
||
|
blob* |
char |
character |
|
|
clob* |
date |
dec |
|
|
decimal |
float |
integer |
|
|
interval_day_to_second |
interval_year_to_month |
long |
|
|
nchar |
nvarchar2 |
number |
|
|
numeric |
raw* |
real |
|
|
ref cursor |
rowid* |
timestamp |
|
|
timestampwithtimezone |
timestampwithlocaltimezone |
urowid* |
|
|
varchar |
varchar2 |
||
|
Unsupported |
|||
|
The data types that are marked with a "*" symbol can only be used in SELECTBLOB and UPDATEBLOB SQL statements. |
|||
|
IBM DB2 Server |
Supported |
||
|
bigint |
blob* |
char |
|
|
clob* |
date |
dbclob* |
|
|
decimal |
double |
graphic |
|
|
integer |
real |
smallint |
|
|
time |
timestamp |
varchar |
|
|
vargraphic |
|||
|
Unsupported |
|||
|
The data types that are marked with a "*" symbol can only be used in SELECTBLOB and UPDATEBLOB SQL statements. Use Double variables instead of Real variables when obtaining float data from the database. |
|||
|
SAP IQ |
Supported |
||
|
bigint |
binary* |
blob* |
|
|
char |
clob |
date |
|
|
datetime |
decimal |
float |
|
|
hs_blockmapidentity* |
hs_vdoidentity* |
hs_vdorecid* |
|
|
image |
int |
long_binary* |
|
|
long_varchar |
money |
numeric |
|
|
oldbit |
real |
rowid |
|
|
smalldatetime |
smallint |
sysname |
|
|
time |
timestamp |
text |
|
|
tinyint |
uniqueidentifier* |
uniqueidentifierstr |
|
|
unsigned bigint |
unsigned int |
unsigned smallint |
|
|
varbinary* |
varchar |
xact_id |
|
|
xml |
|||
|
Unsupported |
|||
|
The data types that are marked with a "*" symbol can only be used in SELECTBLOB and UPDATEBLOB SQL statements. |
|||
|
Informix |
Supported |
||
|
blob* |
boolean |
byte* |
|
|
char |
clob* |
date |
|
|
datetime |
decimal |
float |
|
|
int8 |
integer |
interval |
|
|
lvarchar |
money |
nchar |
|
|
nvarchar |
real |
serial |
|
|
serial8 |
smallint |
text |
|
|
time |
varchar |
||
|
Unsupported |
|||
|
The data types that are marked with a "*" symbol can only be used in SELECTBLOB and UPDATEBLOB SQL statements. (* .NET only) The NumericScale attribute is unsupported. |
|||
