Sybase 12.4.2 User Manual

CHAPTER 5    Moving Data In and Out of Databases

•

When an arithmetic operation results in a higher scale than the 
predetermined scale, Adaptive Server IQ truncates the results to fit the 
scale after it has been determined using the rules defined in the Adaptive 
Server IQ Reference Manual.

If your results require rounding of the values instead of truncation, you should 
use the 

ROUND

 function in your command. However, for inserts, the 

ROUND

 

function can only be part of its query expression.

The maximum precision for numeric data is 126.

The tables below show which Adaptive Server IQ data types are compatible 
with Adaptive Server Enterprise data types. 

Here are some general rules:

•

Adaptive Server IQ character string types accept any Adaptive Server 
Enterprise character string type.

•

Adaptive Server IQ exact numeric types accept any Adaptive Server 
Enterprise number types. However, if the Adaptive Server IQ data type 
holds a smaller amount of data than the Adaptive Server Enterprise type, 
the value converts to a NULL (for example, when inserting data from the 
underlying database into tables).

•

Adaptive Server IQ date/time types accept any Adaptive Server Enterprise 
date/time types.

These Adaptive Server Enterprise data types are not supported by Adaptive 
Server IQ in this version:

•

nchar

•

nvarchar

•

text

•

varbinary

•

image