Range limitations in data type mapping

Some data types have different ranges in SQL Anywhere than in Open Client. In such cases, overflow errors can occur during retrieval or insertion of data.

The following table lists Open Client application data types that can be mapped to SQL Anywhere data types, but with some restriction in the range of possible values.

The Open Client data type is usually mapped to a SQL Anywhere data type with a greater range of possible values. As a result, it is possible to pass a value to SQL Anywhere that will be accepted and stored in a database, but that is too large to be fetched by an Open Client application.

Data type Open Client lower range Open Client upper range SQL Anywhere lower range SQL Anywhere upper range
MONEY -922 377 203 685 477.5808 922 377 203 685 477.5807 -999 999 999 999 999.9999 999 999 999 999 999.9999
SMALLMONEY -214 748.3648 214 748.3647 -999 999.9999 -999 999.9999
DATETIME [1] January 1, 1753 December 31, 9999 January 1, 0001 December 31, 9999
SMALLDATETIME January 1, 1900 June 6, 2079 January 1, 0001 December 31, 9999

[1] For versions earlier than OpenClient 15.5; otherwise, the full range of dates from 0001-01-01 to 9999-12-31 is supported.

 Example
 Timestamps