Re: upgrading to 8.3, utf-8 and latin2 locale problem - Mailing list pgsql-general

Mage <mage@mage.hu> writes:
> What is the proper use of "create database xxxx encoding = 'yyy'" in
> postgresql 8.3?

If you're not using C locale, it has no use whatsoever.

> If I understand You, I should avoid it totally, and
> convert every affected database dumps to UTF-8, load them and use "alter
> database xxx set client_encoding = 'latin2'". Is it right?

Yes, that's what I'd suggest.

            regards, tom lane