Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Unicode and ANSI Interfaces


The Mimer ODBC driver is Unicode based. This allows applications to use both the ANSI and Unicode interfaces when using Mimer SQL. Unicode based applications can both store and retrieve Unicode data through SQL statements and/or Unicode host variables.

ANSI applications can use Unicode host variables, but are restricted to character (8-bit) characters when passing data with SQL statements. Please note that database objects still have to be named with the same character set as before.

The Unicode SQL data types in Mimer SQL are called NATIONAL CHARACTER (or NCHAR), NATIONAL CHARACTER VARYING (NCHAR VARYING), and NATIONAL CHARACTER LARGE OBJECT (NCLOB).

You can find more information about these data types in the Mimer SQL Reference Manual. The ODBC documentation contains specifics about the SQL_WCHAR database type and the SQL_C_WCHAR and SQL_C_WLONGVARCHAR host language types.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX