Alpha - PostgreSQL
The table below lists Magic xpa’s Alpha attribute with the valid PostgreSQL data types.
Each entry in the table has a default data type that can be forced by specifying that type in the Type property of the SQL section in the Column Properties sheet.
Note: n is the specified picture number.
|
|
|
|
|
|
String
|
n, 1-2000
|
n, 1-2000
|
VARCHAR
|
|
|
n, >= 2001
|
n, 2001-32000
|
TEXT
|
|
Lstring
|
n, 1-255
|
n+1, 2-256
|
BYTEA
|
|
Zstring
|
n, 1-2000
|
n+1, 2-2001
|
VARCHAR
|
|
|
n, >= 2001
|
n+1, 2002-32001
|
TEXT
|
|
String Memo
|
n
|
n+2, 32002
|
BYTEA
|
|
Magic Memo
|
n
|
n+2, 32002
|
BYTEA
|
