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:

The string starting with co.. comes before cô...

In unicode_french collation, the Unicode strings are sorted in the following order:

The strings ending in ..e are sorted before strings ending in ..é.

You can create a Unicode enabled database with unicode_french collation as follows:

or