MX 2.x)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows—527888-004

5-10

ODBC Data Types

CONVERT Function

ODBC/MX uses the SQL/MX CAST function to support the ODBC CONVERT function.

The ODBC CONVERT function has the following format:

{ fn CONVERT( value_exp, data_type ) }

The SQL/MX CAST has this format:

CAST( {value_exp | NULL } AS data_type )

SQL/MX translates the CONVERT syntax to the CAST syntax, converting the data type

argument to its equivalent SQL/MX value. For example, if the ODBC data type

parameter for character data is an integer value (SQL_CHAR or 1), the equivalent

SQL/MX data type is a string literal with a value of CHARACTER.

ODBC Data Types

Table 5-14. System Functions

ODBC Function SQL/MX Equivalent Function

DATABASE Not supported in this release.

IFNULL Not supported in this release.

USER USER

Table 5-15. ODBC Data Types (page 1 of 2)

ODBC

Data Type

SQL/MX

Data Type

SQL/MP

Data Type

Supported by

ODBC/MX

CHAR(n) CHAR(n) CHAR(n)Yes

VARCHAR(n) VARCHAR(n) * VARCHAR(n)* Yes

LONGVARCHAR VARCHAR(n) VARCHAR(n)Yes

DECIMAL(p,s)DECIMAL(p,s) DECIMAL(p,s)Yes

NUMERIC(p,s) NUMERIC(p,s) NUMERIC(p,s)Yes

SMALLINT SMALLINT SMALLINT Yes

INTEGER INTEGER INTEGER Yes

REAL REAL REAL Yes

FLOAT(p)FLOAT(p)FLOAT(p)Yes

DOUBLE PRECISION DOUBLE PRECISION DOUBLE

PRECISION

Yes

BIT Not supported Not supported No

TINYINT Not supported Not supported No

TINYINT UNSIGNED Not supported Not supported No

BIGINT LARGEINT LARGEINT Yes