Στις Wednesday 03 February 2010 21:16:36 ο/η Peter Eisentraut έγραψε: > On ons, 2010-02-03 at 17:05 +0200, Achilleas Mantzios wrote: > > Στις Wednesday 03 February 2010 16:53:20 ο/η Peter Eisentraut έγραψε: > > > On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote: > > > > It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD > > > > are two different stories, hence the seen results. > > > > > > The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken. > > > > > > This is becoming a FAQ ... ^^^^ I guess you are right. In my new FreeBSD system i get: postgres@smadevnew:~> uname -sr FreeBSD 8.0-RELEASE-p2 postgres@smadevnew:~> ls -l /usr/share/locale/en_US.UTF-8/ total 0 lrwxr-xr-x 1 root wheel 28 Nov 21 16:30 LC_COLLATE -> ../la_LN.US-ASCII/LC_COLLATE lrwxr-xr-x 1 root wheel 17 Nov 21 16:30 LC_CTYPE -> ../UTF-8/LC_CTYPE lrwxr-xr-x 1 root wheel 30 Nov 21 16:30 LC_MESSAGES -> ../en_US.ISO8859-1/LC_MESSAGES lrwxr-xr-x 1 root wheel 30 Nov 21 16:30 LC_MONETARY -> ../en_US.ISO8859-1/LC_MONETARY lrwxr-xr-x 1 root wheel 29 Nov 21 16:30 LC_NUMERIC -> ../en_US.ISO8859-1/LC_NUMERIC lrwxr-xr-x 1 root wheel 26 Nov 21 16:30 LC_TIME -> ../en_US.ISO8859-1/LC_TIME > > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
