encoding and LIKE/ILIKE matching - Mailing list pgsql-general

From viktor@lacina.org
Subject encoding and LIKE/ILIKE matching
Date
Msg-id 20030922104730.GC1235@pixla.office.bonicom.cz
Whole thread Raw
List 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 by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: How to find LIMIT in SQL standard
Next
From: Robert Treat
Date:
Subject: Re: OT: HEADS-UP: viral storm out there