Database server and data types

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.