Database Unicode Support (Magic xpa 4.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.

Unicode Field Definition

Fields with the Unicode attribute are created in the databases according to the following table:

Get Definition

When you carry out a Get Definition operation, all data types that can contain Unicode data, will automatically be defined as Unicode fields.

Import from Previous Versions

If an Alpha field contains the Unicode character set, the field will be converted from an Alpha field to a Unicode field.