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
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 |