ODBC Data Management

From CometWiki

(Difference between revisions)
Jump to: navigation, search
 
Line 23: Line 23:
* Application defined.
* Application defined.
-
** Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.
+
* Smaller of decimal (dd.ddd) or exponential (d.dddEdd) notation.
-
*** Internet Basic Date/Time numeric functions.
+
* 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.