How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin?

0
Posted

How can i change database encoding for a PostgreSQL database using sql or phpPgAdmin?

0

You have to perform: • database dump, • delete database, • create database with new encoding, • import data from dump created in point 1. Changing it on-the-fly isn’t possible as it would require rewriting most of internal database data which is almost equal to recreating db way I described.

Related Questions