| From: | "Thomas Robak" <thomas(dot)robak(at)dataplexx(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2161: ILIKE does not work with german umlauts in UTF8 |
| Date: | 2006-01-10 13:38:40 |
| Message-ID: | 20060110133840.5894AF0A32@svr2.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nick Martens | 2006-01-10 18:02:21 | possible when setting the timezone |
| Previous Message | canglong | 2006-01-10 06:25:32 | BUG #2160: All the user and Databases are display at client! |