Depending on the language, there can be three different sort orders used under the Latin1 character set:
- Default (for example, U.S.)
- Danish/Norwegian
- Swedish/Finnish
The different sort orders affect the way non-English alphabetic characters are sorted in Latin1. These characters (e.g., Æ, Å, Ø, Ü) in their native language are generally sorted after Z, but in default sort order are placed after the English characters they most resemble (e.g., Å after A, Ø after O).
MapInfo Pro, when running under Latin1, is capable of handling indices in any of the three possible sort orders. You can open tables in Danish/Norwegian or Swedish/Finnish sort order in U.S. MapInfo Pro and perform the following operations on them:
- Save Copy As - Lets you open a table with indices in Danish/Norwegian or Swedish/Finnish sort order. When you use Save Copy As, the file saves in Default U.S. sort order.
This command is located on the HOME tab, in the File group.
- Find or Geocode - Use these commands on tables in different sort orders.
These commands are located on the TABLE tab, in the Selection group, and on the SPATIAL tab, in the Create group.
SQL Selects involving joins, group by's, and order by's - Use the SQL Select command on tables in different sort orders. The results will be in default U.S. sort order. This command is located on the TABLE tab, in the Selection group.
Adding and Dropping Indexes
On the TABLE tab, in the Maintenance group, click Table, and Modify Structure, and then add and drop indices on a table in a different sort order. If you add or drop an index on the table and there are other indexes on the table, the indexes will remain in their original sort order. If you add or drop an index on the table and there are no other indexes remaining on the table, the indexes will change to the Default U.S. sort order.