ODBC Data Management
From CometWiki
(Difference between revisions)
Badge (Talk | contribs)
(New page: '''ODBC Data Management''' '''Data Types''' Supported SQL data types include the following: SQL Type Internet Basic Type ============================================= SQL_CHAR St...)
Newer edit →
(New page: '''ODBC Data Management''' '''Data Types''' Supported SQL data types include the following: SQL Type Internet Basic Type ============================================= SQL_CHAR St...)
Newer edit →
Revision as of 09:51, 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.
- Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.