Re: Help on collation and accent sensitivity

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Help on collation and accent sensitivity
Дата
Msg-id 200512081052.19123.peter_e@gmx.net
обсуждение исходный текст
Ответ на Help on collation and accent sensitivity  ("jlmssilva" <jlmssilva@netcabo.pt>)
Список pgsql-general
jlmssilva wrote:
> I'm experienced with SQL Server (now learning pg)
> and there only by choosing the appropriate collation I get
> case/accent sensitivity policy well defined. Is there any similar
> parameter in pg that I've missed and have the same effect?

You could try to define your own locale, but I'm not sure how that works
on Windows.

Rumour has it that some people to accent-insensitive comparisons using
the to_ascii function.  Since the notion of accent-sensitivity differs
between languages, it'd probably be best if you wrote your own
conversion function.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Hannes Dorbath
Дата:
Сообщение: Re: TSearch2 / Get all unique lexems
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: fts, compond words?