| 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: | Whole Thread | Raw Message | 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 |