Re: Regexp match with accented character problem

Поиск
Список
Период
Сортировка
От Laslo Forro
Тема Re: Regexp match with accented character problem
Дата
Msg-id AANLkTinkzeN3iaQ69ts_sWeQaxA1DvkVLkHeacOEo6B6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regexp match with accented character problem  (Thom Brown <thombrown@gmail.com>)
Ответы Re: Regexp match with accented character problem
Список pgsql-novice
Дерево обсуждения
test=# \l
                                  List of databases
   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
 test      | salmonix | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
(5 rows)


On Tue, Jun 8, 2010 at 12:24 PM, Thom Brown <thombrown@gmail.com> wrote:
On 8 June 2010 10:57, Laslo Forro <getforum@gmail.com> wrote:
> Thanx for your response!
> You write:
>>test=# select * from texts where title ~* E'\\mmacskacicó\\M';
>>
>>That works for me.
> However, it doesn't work for me (if I understand you right):

I suspect your database encoding is SQL_ASCII instead of UTF8.  Can
you tell us your database encoding?

Thanks

Thom

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