APPX Software Library

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