| From: | viktor(at)lacina(dot)org |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | encoding and LIKE/ILIKE matching |
| Date: | 2003-09-22 10:55:18 |
| Message-ID: | 20030922105518.GF1235@pixla.office.bonicom.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cornelia Boenigk | 2003-09-22 11:16:46 | Re: [GENERAL] Warning: PostgreSQL query failed |
| Previous Message | viktor | 2003-09-22 10:47:30 | encoding and LIKE/ILIKE matching |