Logical - MySQL (Magic xpa 2.x)
The table below lists Magic xpa’s Logical attribute and the valid data types for MySQL. The 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
|
MySQL Data
Type
|
|
Integer Logical
|
5
|
1,2
|
SQL_BIT
|
|
String Logical
|
5
|
1
|
SQL_BINARY
|
|
Note:
|
When using the MySQL ODBC 5.1 driver, do not use the Integer Logical storage type since there is a problem using this storage type with this specific driver.
The MySQL ODBC 3.51 driver does not have this problem.
|
