Thread: Changing the encoding of the database on the fly

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!

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