Recommended RDS datatype to SQL datatype mappings

For optimal performance, Sybase recommends that you map the following RDS datatypes to the following database column types.

**Table 2-1: RDS datatype to SQL datatype mappings**
RDS datatype	ASE datatype	Sybase IQ datatype
uint8	tinyint	tinyint
uint16	unsigned smallint	unsigned int (IQ has no unsigned smallint)
uint32	unsigned int	unsigned int
uint64	unsigned bigint	unsigned bigint
sint8	smallint (ASE has no signed 8-bit integer)	smallint (IQ has no signed 8-bit integer)
sint16	smallint	smallint
sint32	int	int
sint64	bigint	bigint
decimal( p, s )	numeric( p, s ) or decimal( p, s )	numeric( p, s ) or decimal( p, s )
datetime	datetime or smalldatetime	timestamp
date	date or smalldate	date
time	time	time
string	char(n) or varchar(n) n <255*	char(n) or varchar(n) n <255*

Notes

If you know that data for a column is always be less than a specific length, then setting n to be as small as possible yields better performance.
For maximum performance using the Publisher API to set decimal fields, the pub_setDecimalFieldFromMantissa API should be used instead of the pub_setDecimal API, if you can obtain the desired value in a format other than a double.