Locale, encoding, sort order confusion

From: John Gunther <postgresql(at)bucksvsbytes(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Locale, encoding, sort order confusion
Date: 2006-08-19 22:37:32
Message-ID: 44E792AC.4050608@bucksvsbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been reading about locales, encodings, sort orders, the to_ascii
function but I'm more confused than enlightened.

What I want is very simple:
1) I want the database to correctly accept, store, and display
alphabetic characters, including European accented characters, entered
and viewed in HTML
forms.
2) I want sorting to ignore the diacritical marks so that, for example,
u, u-accent, and u-umlaut are all sorted as if they were plain u.
3) I want sorting to ignore non-alphanumerics, letter case, and white
space.

To illustrate, the following data is in sorted order:

St-Émile
stendahl
st ènders
St. Epson

Can someone tell me what combination of PostgreSQL and Linux settings I
need for this? Or point me somewhere that it's well explained. It seems
like a very basic question, but I'm just dense,
I guess. I've tried a half dozen time-consuming configs without success.

Thank you.

John Gunther

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2006-08-19 22:38:19 Re: Cast null string '' to integer 0
Previous Message John Gunther 2006-08-19 22:28:35 Locale, encoding, sort order confusion