Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Converting Open Client/Server datatypes to target datatypes [Table of Contents] Chapter 5 Understanding
the request process

Access Service User's Guide DirectConnect for AS/400

[-] Chapter 4 Converting datatypes
[-] Corresponding Open Client/Server and Adaptive Server datatypes

Corresponding Open Client/Server and Adaptive Server datatypes

The following table shows corresponding Open Client/Server and Adaptive Server datatypes.

Open Client/Server and Adaptive Server datatypes

Open Client/Server Datatype

Corresponding Adaptive Server Datatype

CS_BINARY

binary, varbinary

CS_LONGBINARY

NONE

CS_BIT

bit

CS_CHAR

char, varchar

CS_LONGCHAR

NONE

CS_DATETIME

datetime

CS_DATETIME4

smalldatetime

CS_TINYINT

tinyint

CS_SMALLINT

smallint

CS_INT

int

CS_DECIMAL

decimal

CS_NUMERIC

numeric

CS_FLOAT

float

CS_REAL

real

CS_MONEY

money

CS_MONEY4

smallmoney

CS_TEXT

text

CS_IMAGE

image


Converting Open Client/Server datatypes to target datatypes [Table of Contents] Chapter 5 Understanding
the request process