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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |