Chapter 10: Using Destination-Template Transfer
Datatype conversion for transfer to statements
Datatype conversion takes place in two steps. The following
table shows how incoming target ODBC datatypes are initially converted
to Open Server datatypes.
Table 10-6: Datatype
conversion for transfer to statements
ODBC datatype
|
Open Server datatype
|
CHAR
|
CS_CHAR
|
VARCHAR
|
CS_CHAR
|
LONGVARCHAR
|
CS_TEXT
|
SMALLINT
|
CS_SMALLINT
|
INT
|
CS_INT
|
DECIMAL
|
CS_DECIMAL
|
DOUBLE
|
CS_FLOAT
|
REAL
|
CS_REAL
|
FLOAT
|
CS_FLOAT
|
DATE
|
CS_CHAR
|
TIME
|
CS_CHAR
|
TIMESTAMP
|
CS_CHAR
|
BINARY
|
CS_BINARY
|
VARBINARY
|
CS_VARBINARY
|
LONGVARBINARY
|
CS_IMAGE
|
TINYINT
|
CS_TINYINT
|
BIT
|
CS_BIT
|
BIGINT
|
CS_FLOAT
|
NUMERIC
|
CS_NUMERIC
|
These datatypes are converted into the datatypes specified
by the destinationtemplatestatement datatype
qualifiers.
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF