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