Case Sensitive FileMaker Searches And Sorts

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Unicode Indexing is an option for field indexing that uses an international internal number code to distinguish the characters in a field. This form of indexing is case sensitive (a nice option sometimes but does put an extra burden on searches and sorts).

I was told once that the indexing option you choose for a field doesn’t affect the speed of sorting records. If this is true, this doesn’t mean that the index language chosen for a sort will affect the sorting results. This can definitely affect the results of your sort order.

Here you can see an ascending sort on the name field and it has default indexing assigned.

Here you can see an ascending sort on the name2 two and it has unicode indexing assigned. Notice how capital letters are sorted first and the lower characters are sorted later in an ascending sort.

Here you can see that at the bottom on your language sorting options is the Unicode option.