ODBC Data Management

From CometWiki

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.