APPX field type mappings
Column types observed when APPX created a table. Each column identifies the database, APPX engine, operating system, and driver used in the test.
For examples of every field type, see the APPX field type reference.
Tested mappings
| APPX dictionary field |
MariaDB 10.11.18
APPX 6.2.1 (64-bit) · Rocky Linux 9.8
FMS 6 (ODBC) · MariaDB Connector/ODBC 3.1.22 (64-bit)
utf8mb4 database and connection, LOK proxy
Test file DMO COUNTRY
MariaDB 10.11.18 setup guide
|
MariaDB 10.11.18
APPX 6.2.1 (64-bit) · Windows 11 25H2
FMS 6 (ODBC) · MariaDB Connector/ODBC 3.2.9 (64-bit)
utf8mb4 database and connection, LOK proxy
Test file DMO COUNTRY
MariaDB 10.11.18 setup guide
|
Oracle 19.3
APPX 6.2.1 (64-bit) · Rocky Linux 9.8
FMS 5 (OCI) · Oracle Instant Client 19.28 Basic Light (64-bit)
AL32UTF8, default alpha mapping
Test file DMO COUNTRY
Oracle 19.3 setup guide
|
Oracle 19.3
APPX 6.2.1 (64-bit) · Windows 11 25H2
FMS 5 (OCI) · Oracle Instant Client 19.28 Basic Light (64-bit)
AL32UTF8, default alpha mapping
Test file DMO COUNTRY
Oracle 19.3 setup guide
|
PostgreSQL 14.1
APPX 5.5.1a (32-bit) · Rocky Linux 9.8
FMS 6 (ODBC) · psqlODBC ANSI 18.00.0001 (32-bit)
WIN1252 database and connection, Bools as Char cleared
Test file DMO COUNTRY
PostgreSQL 14.1 setup guide
|
PostgreSQL 14.1
APPX 5.5.1a (32-bit) · Windows 11
FMS 6 (ODBC) · psqlODBC ANSI 18.00.0001 (32-bit)
Bools as Char cleared
Test file DMO COUNTRY
PostgreSQL 14.1 setup guide
|
SQL Server 2022
APPX 6.2.1 (64-bit) · Windows 11 25H2
FMS 6 (ODBC) · Microsoft ODBC Driver 18.4.1.1 (64-bit)
SQL Server build 16.0.1160.1, UTF-8 database collation, default FMS options
Test file DMO COUNTRY
SQL Server 2022 setup guide
|
|---|---|---|---|---|---|---|---|
| Alpha14 characters, key field | varchar(56)Example country_name |
varchar(56)Example country_name |
CHAR(14 CHAR)Example COUNTRY_NAME |
CHAR(14 CHAR)Example COUNTRY_NAME |
varchar(14)Example country_name |
varchar(14)Example country_name |
nvarchar(56)Example country_nameSQL Server reports 112 bytes in sys.columns. |
| Logic | bit(1)Example country_city_sep_line |
bit(1)Example country_city_sep_line |
CHAR(1 CHAR)Example COUNTRY_CITY_SEP_LINE |
CHAR(1 CHAR)Example COUNTRY_CITY_SEP_LINE |
booleanExample country_city_sep_line |
booleanExample country_city_sep_line |
bitExample country_city_sep_line |
| Numeric2 digits, 0 decimals | varchar(2)Example country_no_words |
varchar(2)Example country_no_words |
NUMBER(2,0)Example COUNTRY_NO_WORDS |
NUMBER(2,0)Example COUNTRY_NO_WORDS |
numeric(2,0)Example country_no_words |
numeric(2,0)Example country_no_words |
numeric(2,0)Example country_no_words |
| User Added | varchar(3)Example country_added_by |
varchar(3)Example country_added_by |
CHAR(3 CHAR)Example COUNTRY_ADDED_BY |
CHAR(3 CHAR)Example COUNTRY_ADDED_BY |
varchar(3)Example country_added_by |
varchar(3)Example country_added_by |
varchar(3)Example country_added_by |
| Date AddedCCYYMMDD | dateExample country_date_added |
dateExample country_date_added |
VARCHAR2(8 CHAR)Example COUNTRY_DATE_ADDED |
VARCHAR2(8 BYTE)Example COUNTRY_DATE_ADDED |
dateExample country_date_added |
dateExample country_date_added |
dateExample country_date_added |
Compare the full field definition. Length, decimal places, date components, and driver settings can affect the column type. For an existing table, check Field Overrides in File Specifications. APPX field-to-column mapping options