Re: Accent insensitive search?

Поиск
Список
Период
Сортировка
От Christophe
Тема Re: Accent insensitive search?
Дата
Msg-id D7509483-1274-4694-A488-E71D37C67A71@thebuild.com
обсуждение исходный текст
Ответ на Re: Accent insensitive search?  (Sam Mason <sam@samason.me.uk>)
Список pgsql-general
What I've done in the past in this situation is to create a separate
field with the text normalized to whatever the search form is (all
lower case, accents stripped, etc.), and then index and search that
from the application.

Although I've not tried it, a functional index that did the same thing
might work, as long as you were careful in how the queries were
written to ensure that it was used.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Will Rutherdale (rutherw)"
Дата:
Сообщение: Re: DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently
Следующее
От: Jeffrey Trimble
Дата:
Сообщение: configure question