Salesforce

Database Unicode Support (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

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.

Database

Columns

Statements

Notes

MS-SQL

?

?

Oracle

?

Version 9

ODBC

?

Requires ODBC 3.5

DB/2

?

Version 9

Pervasive

?

Version 12

DB/2 400

?

ISAM 400

?

Does not support Indexes


Unicode Field Definition

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

Database

Length

Definition

SQL-Server

<=4000

NCHAR
NVARCHAR

>4000

NTEXT

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.

Reference
Attachment 
Attachment