ODBC Data Management

From CometWiki

Revision as of 09:51, 29 May 2009 by Badge (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.
Personal tools