Database Unicode Support (Magic xpa 2.x)
Magic xpa's Unicode support means that you can use Unicode fields in conjunction with multi-byte data. You can use any Magic xpa operations available at the field level with Unicode fields as well. The operations include range, locate, and sorting.
Database support of Unicode is determined according to several parameters:
-
Unicode columns and indexes in table definition, which includes binding of Unicode data into statements
-
Execution of a Unicode statement (including the SELECT .. command) by different databases,
as described in the table below.
|
|
|
|
|
|
MS-SQL
|
v
|
v
|
|
|
Oracle
|
v
|
|
Version 9
|
|
ODBC
|
v
|
|
Requires ODBC 3.5
|
|
DB/2
|
v
|
|
Version 9
|
|
Pervasive
|
v
|
|
Version 8
|
|
DB/2 400
|
v
|
|
|
|
ISAM 400
|
v
|
|
Does not support Indexes
|
Fields with the Unicode attribute are created in the databases according to the following table:
|
|
|
|
|
SQL-Server
|
<=4000
|
NCHAR
NVARCHAR
|
|
|
>4000
|
NTEXT
|
When you carry out a Get Definition operation, all data types that can contain Unicode data, will automatically be defined as Unicode fields.
If an Alpha field contains the Unicode character set, the field will be converted from an Alpha field to a Unicode field.
