Sorting based on Locale

The MiniVend [sort database:field] keys will use the LC_COLLATE setting for a locale provided that:

Your operating system and C compiler have such support for POSIX, and you have the locale definitions set.
The locale setting matches one of your configured locales.

It is beyond the scope of this document to discuss these issues, and you should contact your system administrator or local wizard to help you set up locales on your system. NOTE: Windows locales are not supported for sorting.

If you had this arbitrary database named letters:

    code        letter
    00-0011     f
    99-102      é
    19-202      a

and this loop:

    [loop 19-202 00-0011 99-102]
    [sort letters:letter]
    [loop-data letters letter]   [loop-code]
    [/loop]

Using the default C setting for LC_COLLATE it would display:

    a  19-202
    f  00-0011
    é  99-102

If the proper LC_COLLATE settings for locale fr_FR were in effect, then it would become:

    a  19-202
    é  99-102
    f  00-0011

Index Up << >>

Sorting based on Locale

Index Up << >>