About using right-to-left sort orders
The default Access sort order, General, handles sorting of right-to-left characters; that is, there are no separate sort orders for right-to-left languages. General sort order now includes right-to-left characters because characters are stored as Unicode values. The behavior of General sort order for right-to-left characters stored as Unicode values is identical to the behavior of right-to-left characters previously stored as Arabic or Hebrew code page values and sorted by using Arabic sort order and Hebrew sort order, respectively.
Right-to-left text is sorted along the following guidelines:
- Left-to-right text is always sorted ahead of right-to-left text
- Sort ignores kashidas and bidirectional control characters
- Characters with diacritics are clustered after other occurrences of the base character
Note When opened or imported, previous-version databases that use a right-to-left sort order are saved with the Access General sort order.