Alpha - MySQL (Magic xpa 2.x)
The table below lists Magic xpa’s Alpha attribute and the valid data types for 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.
Note: n is the specified picture number.
|
Magic xpa Storage
Type
|
Magic xpa Picture
|
Magic xpa
Storage Size
|
MySQL
Data Type
|
|
String
|
n,1-32700
|
n,1-32700
|
SQL_LONGVARBINARY
|
|
Lstring
|
n, 1-255
|
n+1, 2-256
|
SQL_BINARY
|
|
Zstring
|
n, 1-7999
|
n+1, 2-8000
|
SQL_VARCHAR
|
|
|
n, 8001-32700
|
n+1, 8002-32701
|
SQL_LONGVARCHAR
|
|
String Memo
|
n, 1-32700
|
n+2
|
SQL_VARBINARY
|
|
Magic Memo
|
n, 32700
|
n+2
|
SQL_LONGVARBINARY
|
