Обсуждение: Changing the encoding of the database on the fly

Поиск
Список
Период
Сортировка

Changing the encoding of the database on the fly

От
Michael Kichanov
Дата:
Hi All!

Can i change the encoding of the database with "update pg_database set encoding= where datname="
without any problem with DB integrity?

Thanx in advance!

Re: Changing the encoding of the database on the fly

От
Tom Lane
Дата:
Michael Kichanov <mike@inar.ru> writes:
> Can i change the encoding of the database with "update pg_database set encoding= where datname="
> without any problem with DB integrity?

No.  That's not going to magically fix your data to be correct in the
new encoding.

            regards, tom lane