Specifies the Open Client and Open Server datatype to which an access service converts DECIMAL results.
DecimalResults=[autoconvert | int | float | real | char | money | money4 | bcd]
autoconvert
autoconvert allows the access service to choose the appropriate datatype to return according to the following conversion scheme:
If scale = 0 and precision is less than or equal to 9, the access service returns CS_INT.
If scale is less than or equal to 4, and precision minus scale is less than or equal to 19, the access service returns CS_MONEY.
If scale is greater than 2, and precision minus scale is greater than 14, the access service returns CS_FLOAT.
int returns a 4-byte integer type.
float returns an 8-byte float type.
real returns a 4-byte float type.
char returns a character type. However, decimal points are not aligned consistently with those in the ODBC DECIMAL columns.
money returns an 8-byte money type.
money4 returns a 4-byte money type.
bcd is valid only if you have columns described in binary coded decimal (BCD) format. The access service returns BCD columns as CS_BINARY or CS_VARBINARY with the following format:
If precision is even, the first nibble is 0.
Intervening digits are represented in BCD format with one nibble per digit.
The final nibble indicates the sign: C is positive and D is negative.
No indication of decimal position is given. The client application is responsible for determining decimal position.
In some ODBC data sources, the ODBC decimal type is not supported. In such cases, it is not supported as a Sybase datatype.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
