ODBC Data Management
From CometWiki
(Difference between revisions)
(New page: '''ODBC Data Management''' '''Data Types''' Supported SQL data types include the following: SQL Type Internet Basic Type ============================================= SQL_CHAR St...) |
|||
| Line 4: | Line 4: | ||
Supported SQL data types include the following: | Supported SQL data types include the following: | ||
| - | + | ||
| - | SQL Type | + | SQL Type Internet Basic Type |
| - | ============================================= | + | ============================================= |
| - | SQL_CHAR | + | SQL_CHAR String |
| - | SQL_VARCHAR String | + | SQL_VARCHAR String |
| - | SQL_LONGVARCHAR String | + | SQL_LONGVARCHAR String |
| - | SQL_DECIMAL String/Numeric* | + | SQL_DECIMAL String/Numeric* |
| - | SQL_NUMERIC String/Numeric* | + | SQL_NUMERIC String/Numeric* |
| - | SQL_BIT | + | SQL_BIT String(1)/Numeric(1.0) |
| - | SQL_TINYINT String(4)/Numeric(3.0) | + | SQL_TINYINT String(4)/Numeric(3.0) |
| - | SQL_INTEGER String(11)/Numeric(10.0) | + | SQL_INTEGER String(11)/Numeric(10.0) |
| - | SQL_SMALLINT String(6)/Numeric(5.0) | + | SQL_SMALLINT String(6)/Numeric(5.0) |
| - | SQL_REAL | + | SQL_REAL String(13)** |
| - | SQL_DOUBLE String(22)** | + | SQL_DOUBLE String(22)** |
| - | SQL_DATE | + | SQL_DATE String(6)/Numeric(6.0)*** |
| - | SQL_TIME | + | SQL_TIME String(6)/Numeric(6.0)*** |
| - | SQL_TIMESTAMP | + | SQL_TIMESTAMP String(13) - special “dddddd.ssssss” format |
* 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. | ||
Revision as of 09:53, 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.
