The table below lists Magic xpa’s Unicode attribute and the valid data types in MSSQL. 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
MSSQL Data Type
ZUnicode
n,1-4000
>4000
n*2+2
nVARCHAR
nTEXT
Unicode
n*2