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