| From: | Tomi NA <hefest(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | collation & UTF-8 |
| Date: | 2006-02-24 17:23:07 |
| Message-ID: | d487eb8e0602240923i7cc6c1f8m70440615fdf9c252@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm using PosgreSQL 8.1.2 on linux and want to load UTF-8 encoded varchars.
While I can store and get at stored text correctly, the ORDER BY places all
accented characters (Croatian, in this case - probably marked hr_HR) after
non-accented characters.
This is no showstopper, but it does affect the general perception of
application quality.
Now, I've seen the issue mentioned in a number of places, but often with
fairly old versions of pgsql (<8.0), in different circumstances etc. so my
question is:
is there an official way to set up UTF8 collation so that "SELECT first_name
FROM persons ORDER BY first_name" works as expected?
TIA,
Tomislav
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-02-24 17:29:13 | Re: collation & UTF-8 |
| Previous Message | Scott Marlowe | 2006-02-24 17:15:19 | Re: ltree + gist index performance degrades |