encoding and LIKE/ILIKE matching

Поиск
Список
Период
Сортировка
От viktor@lacina.org
Тема encoding and LIKE/ILIKE matching
Дата
Msg-id 20030922105518.GF1235@pixla.office.bonicom.cz
обсуждение исходный текст
Список pgsql-general
Hi all,
                       

                       
Maybe it's a question or report to bug section, but i'm not sure :-)
                       

                       
I have a database in UTF-8 encoding filled with text in czech laguage.
                       
Everything looks correctly ... by hand translation from UTF8 2 latin2 and
                       
back is correct. But When i make any LIKE or ILIKE comparsion it sometimes
                       
fails. It's realy weird because for example 'Petr<in' IS NOT LIKE
                       
'Petr<%', but 'Petr<in' IS LIKE 'Petr<i%' ;-)
                       
Query is on 100% encoded correctly, it comes in UTF-8 from JDBC. Also data
                       
are correct :-)
                       

                       
Version of PGSQL is 7.3...
                       

                       
Any helpfull idea??
                       

                       
Thanks a lot :-)
                       

                       
Viktor Lacina

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

Предыдущее
От: "Oscar I. del Rey"
Дата:
Сообщение: cannot insert or update
Следующее
От: "shreedhar"
Дата:
Сообщение: Warning: PostgreSQL query failed