5. Customizing Ingres : Local Collation Sequences : Supported Collation Sequences : Unicode_french Collation Sequence
 
Share this page                  
Unicode_french Collation Sequence
The unicode_french collation is applicable to Unicode columns. It follows French sorting order for Unicode character strings where the accented characters are sorted from left to right instead of from right to left.
For example, in the default Unicode collation, the following is the sort order for these four Unicode strings:
cote
coté
côte
côté
The string starting with co.. comes before cô...
In unicode_french collation, the Unicode strings are sorted in the following order:
cote
côte
coté
côté
The strings ending in ..e are sorted before strings ending in ..é.
You can create a Unicode enabled database with unicode_french collation as follows:
createdb ‑iunicode_french unidb
or
createdb ‑nunicode_french unidb