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) and NATIONAL CHARACTER VARYING (NCHAR VARYING).
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 host language type.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40