DecimalResults

DecimalResults=[autoconvert | int | float | real | char | money | money4 | bcd]

• autoconvert allows the access service to choose the appropriate datatype to return according to 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 this 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.