Re: PostgreSQL, Mac OS X and locales

On Wed, Nov 02, 2005 at 07:27:49AM +0100, Guido Neitzer wrote:
> The LC_COLLATE for this locale is a link pointing to "../la_LN.US-
> ASCII/LC_COLLATE". This is why I don't think they paid much attention
> to the correct sort order of umlauts.

Ah you noticed that. Yes, many of the UTF-8 locales in FreeBSD simply
point to the ASCII versions which doesn't exactly work very well.

> But I have also tried ISO-5589-, ISO-8859-15 and others. No change.
> May I take an LC_COLLATE file from another system and use this?

Only another FreeBSD system, these files are not portable. However, the
source files for these are plain text so you can edit them. I beleive
the source is in the C library. Find the source files, edit them and
recompile. Then just copy the LC_COLLATE file over.

You might also want to look at some of the other predefined locale
collate orders, maybe someone has put some effert in getting an order
right for another language.

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.