Salesforce

Alpha - MySQL (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Alpha - MySQL (Magic xpa 4.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

Reference
Attachment 
Attachment