Unicode - MySQL (Magic xpa 2.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
|
