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 по дате отправления: