Обсуждение: Bug #615: Bug in ilke and ~~* Sql expression

Torsten Krämer (tk@kreakom.de) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Bug in ilke and ~~* Sql expression

Long Description
i tried to do a select on some columns case insensitive.
some charachters like äöü.. the ilike,~~*,upper made mistakes

Sample Code
select upper('GaStstÄttEn');
    upper
-------------
 GASTSTÄTTEN
(1 row)

select upper('GaStstättEn');
    upper
-------------
 GASTSTäTTEN
(1 row)


select data_content from feature where data_content ~~* 'GaStstättEn';
=>
 data_content
--------------
 Gaststätten
(1 row)


select data_content from feature where data_content ~~* 'GaStstÄttEn';
=>
 data_content
--------------
(0 rows)

select data_content from feature where upper(data_content)=upper('GaStstättEn');
=>
 data_content
--------------
 Gaststätten
(1 row)

select data_content from feature where upper(data_content)=upper('GaStstÄttEn');
=>
 data_content
--------------
(0 rows)




No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> i tried to do a select on some columns case insensitive.
> some charachters like äöü.. the ilike,~~*,upper made mistakes

Sounds like you didn't initialize the database with the right locale
setting.

            regards, tom lane