Re: [GENERAL] lc_ctype does not work on windows ?

2010-04-27 Thread Tom Lane
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes: > I have a problem with locale on windows. > postgresql 8.4. > this does not work as expected: > filip=# select 'A' ~ '\w', 'Ą' ~ '\w'; The locale-aware regex operators don't really work in multibyte encodings. There's a (partial) fix for this in 9

[GENERAL] lc_ctype does not work on windows ?

2010-04-27 Thread Filip Rembiałkowski
Hi I have a problem with locale on windows. postgresql 8.4. this does not work as expected: filip=# select 'A' ~ '\w', 'Ą' ~ '\w'; ?column? | ?column? --+-- t| f (1 row) -- investigating postgres settings: filip=# select name, setting, context, source, boot_val, reset_