Re: Latvian language & upper & lower - Mailing list pgsql-hackers

On Mon, 7 Jul 2003, Lauris Bukshis wrote:

> LC_COLLATE:                           lv_LV.UTF-8
> LC_CTYPE:                             lv_LV.UTF-8
>
> but when making upper or lower on any text latvian symbols stays on the
> same case. And I can't get lower and upper to work correctly :( Is there
> any such way to get them work correctly? :)

You can only expect this to work if the data in your database is in UTF-8.
If you store them in ISO 8859-x you need to select a different locale,
probably named lv_LV.

-- 
Peter Eisentraut   peter_e@gmx.net