ODBC Data Management
From CometWiki
(Difference between revisions)
| Line 23: | Line 23: | ||
* Application defined. | * Application defined. | ||
| - | + | * Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation. | |
| - | + | * Internet Basic Date/Time numeric functions. | |
Latest revision as of 09:54, 29 May 2009
ODBC Data Management
Data Types
Supported SQL data types include the following:
SQL Type Internet Basic Type ============================================= SQL_CHAR String SQL_VARCHAR String SQL_LONGVARCHAR String SQL_DECIMAL String/Numeric* SQL_NUMERIC String/Numeric* SQL_BIT String(1)/Numeric(1.0) SQL_TINYINT String(4)/Numeric(3.0) SQL_INTEGER String(11)/Numeric(10.0) SQL_SMALLINT String(6)/Numeric(5.0) SQL_REAL String(13)** SQL_DOUBLE String(22)** SQL_DATE String(6)/Numeric(6.0)*** SQL_TIME String(6)/Numeric(6.0)*** SQL_TIMESTAMP String(13) - special “dddddd.ssssss” format
- Application defined.
- Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.
- Internet Basic Date/Time numeric functions.
