sknipe@xxxxxxxxxx wrote:
Our product will be storing its character data in utf-8 format (unicode
encoding).
What is the best way to achive cultural sensitive sorting using the
utf-8 data?
See below.
Is it possible have the locale apply to a connection?
A locale applies to a whole database cluster. That's one locale only.
If so, is the cultural sorting support mature in PostgreSQL?
What type of performance can be expected as compared with the normal c
locale sorting?
Maturity and performance depend upon the underlying libraries, which
depend upon your O.S. - I recommend testing.
There has been discussion of how to support mixed locales, possibly even
within the same column but I don't know whether anyone is working on
this at the present time. The mailing list archives will contain plenty
of discussion on this.
Does that help?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
