Thread: Changing postgres encoding

first off, i'm not 100% sure right place find support, apologies if not.


have inherited roles of our old senior developer/sysadmin (unfortunately without payrise time being ), , i'm trying clear horrible mess has left in.

1 of our major gripes @ moment our database using us-ascii encoding, absolutely horrible. uk based company, having particular issues £ character, or chinese characters, things storing our incoming emails etc.

convert our database utf8. aware of how change , reload configs switch utf8, asking is, how go converting our existing data utf8 well?

understand, postgres has 2 sets of encoding - server encoding , client encoding. both set us-ascii. if arrange maintenance time, , change client encoding utf8 , take dump of database, convert us-ascii characters appropriate utf8 characters?

have had play around pg_dump command, using -e flag attempt take utf8 dump. unfortunately, trying restore dump on development machine both client , server encodings set utf8 results in partial restore - tables may store £ character (for example, our ticketing system) fail restore.

think issue having current us-ascii encoding *somehow* has stored combination of ascii, utf8 , iso 8859-1 characters. typical error message on above restore attempts along lines of:

code:

0xa3 not valid utf8 byte sequence

(for reference 0xa3 byte sequence iso 8859-1 £)

ideas on options are?

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [other] Changing postgres encoding

Ubuntu