unicode regular insensitive matching

Jan Poslusny writes:

then I initdb -E UNICODE,
then I createdb -E UNICODE.

select myfield from mytable where myfield ~* 'MiXeD national-specific
characters' order by myfield

is _NOT_ case insensitive and not ordered according to locales (if I
create another db with LATIN2 charset, all is OK)

Unicode is only a character set. Issues like sorting and letter-case are
determined by the locale. You didn't say which locale you used or wanted
to use, what your input was and what ordering you expected, so there's not
a lot we can do for you.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

I used czech locales, described in attached pg_bash_profile exactly,
briefly here:
LC_ALL=cs_CZ
LC_COLLATE=cs_CZ
LC_CTYPE=cs_CZ
LC_MONETARY=cs_CZ
LC_NUMERIC=cs_CZ
LC_TIME=cs_CZ

I used unicodeSQL script for db with UNICODE charset and latin2SQL
script for db with LATIN2 charset. I hope attached scripts are
self-describing.

I don't know, what is misconfigured or badly used.

thanks for some hint

Peter Eisentraut wrote: