ODBC Data Management

From CometWiki

---

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.