Salesforce

Unicode - MySQL (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Unicode - MySQL (Magic xpa 4.x)

The table below lists Magic xpa’s Unicode attribute and the valid data types in MySQL. Each entry in the table has a default data type that can be forced by specifying that type in the Type property on the SQL section in the Column Properties sheet.

Magic xpa Storage Type

Magic xpa Picture

Magic xpa Storage Size

ODBC Data Type

ZUnicode

n,1-255

>= 256 & < 32000

>= 32000

n*2+2

SQL_WCHAR

SQL_WVARCHAR

SQL_WLONGVARCHAR

Unicode

n,1-255

>= 256 & < 32000

>= 32000

n*2

SQL_WCHAR

SQL_WVARCHAR

SQL_WLONGVARCHAR

Reference
Attachment 
Attachment