Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

BUG #2161: ILIKE does not work with german umlauts in UTF8

1 view
Skip to first unread message

Thomas Robak

unread,
Jan 10, 2006, 8:38:40 AM1/10/06
to

The following bug has been logged online:

Bug reference: 2161
Logged by: Thomas Robak
Email address: thomas...@dataplexx.com
PostgreSQL version: 8.0.3
Operating system: i686-pc-linux-gnu SuSE kernel 2.6.11.4-20a-smp
Description: ILIKE does not work with german umlauts in UTF8
Details:

Querying tables encoded UTF8 containing german umlauts such aus
Ö,ö,Ä,ä,Ü,ü with ILIKE will only return case-sensitive results. For
example:

Table:
|---------------|
| DATA |
|---------------|
| Österreich |
| Niederösterreich |
| Ober Österreich |
|---------------|

Query1= SELECT * FROM table WHERE data ILIKE '%ö%'
Result:
Niederösterreich

Query2= SELECT * FROM table WHERE data ILIKE '%Ö%'
Result:
Österreich
Ober Österreich

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Volkan YAZICI

unread,
Jan 11, 2006, 5:42:14 AM1/11/06
to
On Jan 10 01:38, Thomas Robak wrote:
> Querying tables encoded UTF8 containing german umlauts such aus
> Ö,ö,Ä,ä,Ü,ü with ILIKE will only return case-sensitive results.
> For example:

Please see these posts:
http://archives.postgresql.org/pgsql-bugs/2006-01/msg00063.php
http://archives.postgresql.org/pgsql-general/2005-12/msg00095.php


Regards.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

0 new messages