| From: | Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Valid lc-collate names on Windows |
| Date: | 2010-02-05 10:35:32 |
| Message-ID: | 4B6BF474.3090205@codata.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all
I am trying to find a collation that will support most European languages.
I want something that will sort accentuated 'e' after normal 'e' as in
French, 'n' with a '~' after normal 'n' as in Spanish, German Eszett as
'ss', etc...
Is there a collation that does this on windows ?
I have searched a bit, but I can't find the list of supported collations
on my system (postgresql 8.4, winxp pro french).
In regionnal settins, I have a list of supported locales, but trying
them results in an error (i.e. createdb --lc-collate="Anglais
(États-Unis)" -> ERREUR: nom de locale « Anglais (États-Unis) »
invalide, locale name invalid).
I tried with collation "C" and encoding "UTF8", but is not good at all
since it sorts lowercase letters after uppercase ones.
Thanks in advance for you help on this !
Regards
Arnaud Lesauvage
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2010-02-05 11:17:36 | Re: Literals in foreign key definitions |
| Previous Message | aravind chandu | 2010-02-05 10:06:12 | Query to find list of dates between two dates |