APPX Software Library

Oracle, SQL Server and Other Databases

What rule does APPX / Oracle interface use to decide when a field will be "char" vs "varchar".

The basic rule: if the field is less than six characters long or is a key segment, we use a 'CHAR', otherwise we use a 'VARCHAR'.

You can override that with field-level overrides or by setting "Use VARCHAR for all alpha fields?" to Y (in the FMS group).