The following bug has been logged online:
Bug reference: 2161
Logged by: Thomas Robak
Email address: thomas(dot)robak(at)dataplexx(dot)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 |
| Niedersterreich |
| Ober sterreich |
|---------------|
Query1= SELECT * FROM table WHERE data ILIKE '%%'
Result:
Niedersterreich
Query2= SELECT * FROM table WHERE data ILIKE '%%'
Result:
sterreich
Ober sterreich