Salesforce

Alpha - ODBC (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Alpha - ODBC (Magic xpa 4.x)

The table below lists Magic xpa’s Alpha attribute and the valid data types for ODBC. 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

ODBC Data Type

String

n,1-8000

n,1-8000

CHAR

n, 8001-32700

n, 8001-32700

TEXT

Lstring

n, 1-255

n+1, 2-256

BINARY

Zstring

n, 1-8000

n+1, 2-8001

CHAR

n, 8001-32700

n+1, 8002-32701

TEXT

String Memo

n, 1-7998

n+2

VARBINARY

Magic Memo

n, 7999 and above

n+2

IMAGE

Reference
Attachment 
Attachment