This page provides information about the SQL data types that cannot be used when creating synced record types. If your source table contains a column type that is listed in the section for your database, that column cannot be mapped in your record type.
The various databases you can use with Appian have unique data types that may not be supported for synced record types. In general, Appian does not support binary, large object (LOB), spatial, or XML types, as well as any user-defined types. The following lists are provided as a reference and may not be comprehensive. Vendor-specific and user-defined types are generally not supported and may cause record types to not sync or other issues.
For binary types, you may still be able to manually map a field in your record type to that column, but it is not guaranteed to work correctly and may fail completely with a future version of Appian.
See the individual software sections for information about the specific types not supported by Appian.
Note: If your table includes LONG
or BIGINT
columns, the safe range of values is from -2,147,483,647 to 2,147,483,647. Numbers outside that range may not be synced correctly. See the Number (Integer) data type for more information about number values in Appian.
The following IBM DB2 types are not supported:
BINARY
BLOB
CLOB
DBCLOB
GRAPHIC
The following MariaDB and MySQL types are not supported:
BLOB
BINARY
LONGBLOB
MEDIUMBLOB
MULTILINESTRING
MULTIPOINT
MULTIPOLYGON
POINT
POLYGON
TINYBLOB
VARBINARY
YEAR
The following MS SQL Server types are not supported:
binary
datetimeoffset
geography
geometry
hierarchyid
image
rowversion
sql_variant
varbinary
The following Oracle types are not supported:
BFILE
BINARYDOUBLE
BINARYFLOAT
BLOB
CLOB
INTERVAL_DAY_TOSECOND
INTERVAL_YEAR_TOMONTH
NCLOB
ROWID
TIMESTAMP_WITH_LOCALTZ
TIMESTAMP_WITH_TZ
UROWID
VARBINARY
The following PostgreSQL types are not supported:
BIT
BIT_VARYING
BOX
BYTEA
CIDR
CIRCLE
INET
INTERVAL
JSON
JSONB
LINE
LSEG
MACADDR
MACADDR8
MONEY
PATH
PG_LSN
PG_SNAPSHOT
POINT
POLYGON
TSQUERY
TSVECTOR
TXID_SNAPSHOT
UUID
XML
Unsupported Database Columns in Synced Record Types