Confused about locales
От
John Gunther
Тема
Confused about locales
Дата
Msg-id
44E730F7.7070705@bucksvsbytes.com
Ответ на
Re: A slow query - Help please? (Alban Hertroys)
Список
Дерево обсуждения
A slow query Alban Hertroys <alban@magproductions.nl>
Re: A slow query Alban Hertroys <alban@magproductions.nl>
Re: A slow query - Help please? Alban Hertroys <alban@magproductions.nl>
Confused about locales John Gunther <owner@bucksvsbytes.com>
Re: Confused about locales "Tomi NA" <hefest@gmail.com>
Re: A slow query - Help please? "hubert depesz lubaczewski" <depesz@gmail.com>
Re: A slow query - Help please? Alban Hertroys <alban@magproductions.nl>
Re: A slow query - Help please? "Gurjeet Singh" <singh.gurjeet@gmail.com>
Re: A slow query - Help please? Alban Hertroys <alban@magproductions.nl>
Re: A slow query - Help please? Jim Nasby <jnasby@pervasive.com>
Re: A slow query - Help please? Alban Hertroys <alban@magproductions.nl>
Re: A slow query - Help please? Martijn van Oosterhout <kleptog@svana.org>
Re: A slow query - Help please? Alban Hertroys <alban@magproductions.nl>
Re: A slow query - Help please? Martijn van Oosterhout <kleptog@svana.org>
Re: A slow query - Help please? Alban Hertroys <alban@magproductions.nl>
Re: A slow query - Help please? "hubert depesz lubaczewski" <depesz@gmail.com>
I've been reading about locales, encodings, sort orders, the to_ascii function and, embarrasingly, 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, 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? 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
В списке pgsql-general по дате отправления