Re: 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