When you create a file, FileMaker Pro uses the operating system language setting to determine the language used for indexing text fields and
sorting data. You can choose a different language in the Storage tab of the Options for Field dialog box (for indexing and sorting) and the Sort Records dialog box (for sorting only).
The Default language setting uses the Unicode Collation Algorithm primary and secondary collation weights for indexing and sorting characters without any language-specific tailoring.
The Default setting is useful when you need an index with more character distinctions than you get when you index using a specific language. For example, if you use the French language setting to index records containing the words “demande” and “demandé,” and then use the index to search for the word “demande,” the result contains a set of records that contain either "demande" or “demandé.” If you use the
Default language setting to index the same records, a search for the word “demande” results in the set of records that contain “demande,” but not “demandé.”
When you choose to index or sort by Unicode, characters are distinguished and ordered by their Unicode numeric encoding. This means lowercase and uppercase letters are indexed and sorted separately and punctuation characters are treated as alphanumeric characters.
If you have been using the ASCII setting for sorting and indexing data in previous versions of FileMaker Pro, you can use the
Unicode setting to achieve similar results.