Torsten Kr�mer ([EMAIL PROTECTED]) 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
