Appendix B – International Languages

Within an index definition, the user may specify the “language” of the index.  The language defines what the collation sequence for TEXT fields within the index will be.  The default collation sequence for TEXT data is according to the US language.  Alternate collation sequences may be specified by selecting one of the following language codes:

• AF      - Afrikaans
• AR      - Arabic
• CA      - Catalán
• HR      - Croatian
• CZ      - Czech
• DK     - Danish
• NL      - Dutch
• OZ      - English – Australia
• CE      - English – Canada
• UK     - English – United Kingdom
• US      - English – United States (this is the default)
• FA      - Farsi
• SU      - Finnish
• CF      - French – Canada
• FR      - French – France
• GA     - Galician
• DE      - German – Germany
• SD      - German – Switzerland
• GR      - Greek
• HE      - Hebrew
• HU     - Hungarian
• IS       - Icelandic
• IT       - Italian
• JP       - Japanese
• NO     - Norwegian
• PL      - Polish
• BR      - Portuguese – Brazil
• PO     - Portuguese – Portugal
• RU     - Russian
• SL      - Slovak
• ES      - Spanish
• SV      - Swedish
• YK     - Ukranian
• UR      - Urdu
• TK      - Turkey

NOTE: The collation sequence for each language is not necessarily unique.

The following rules describe the sort order (collating sequence) for characters in TEXT fields:

• White space is sorted BEFORE all other characters
• Characters such as "!@#$%^" etc. are sorted between white space and numeric characters.  These characters may vary from language to language.
• Numeric characters are sorted next (sorted in numeric sequence).
• Alphabetic characters (sorted from lowercase to uppercase with Greek characters 1st, Latin characters 2nd, and Cyrillic characters 3rd.)