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).