Michael Kichanov <mike@xxxxxxx> 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