My environment setup as:
show lc_ctype;
lc_ctype
-
fr_CA.UTF-8
(1 row)
fis=> SELECT 'Ä' ~* 'ä';
?column?
--
f
(1 row)
fis=> SELECT 'Ä' ilike 'ä';
?column?
--
f
(1 row)
I got the same result: false
"=?ISO-8859-1?Q?Ragnar_=D6sterlund?=" <[EMAIL PROTECT
"=?ISO-8859-1?Q?Ragnar_=D6sterlund?=" <[EMAIL PROTECTED]> writes:
> I'm not sure if this is a bug or if I'm doing something wrong. I have
> a database encoded with ISO-8859-1, aka LATIN1. When I do something
> like:
> SELECT 'Ä' ~* 'ä';
> it returns false.
Check the database's locale setting (LC
Hi,
I'm not sure if this is a bug or if I'm doing something wrong. I have
a database encoded with ISO-8859-1, aka LATIN1. When I do something
like:
SELECT 'Ä' ~* 'ä';
it returns false. If i do:
SELECT 'A' ~* 'a';
I get true. According to specification, both should return true.
Anyone knows wh
