By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

encoding and LIKE/ILIKE matching

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.