Skip site navigation (1) Skip section navigation (2)

Re: Changing encoding

From: Ivo Rossacher <rossacher(at)bluewin(dot)ch>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Changing encoding
Date: 2008-07-15 17:26:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
For the SQL_ASCII tables it depends what was actually written to the tables. 
SQL_ASCII means that the server does not do any conversation and that the 
client is responsible for the used encoding. So if there is data in the table 
with different encodings (comming from different clients with different 
encodings) you need to fix this by hand (depending on the data size an 
editor, iconv, recode or similar might help you with this).
The Latin1 tables might be fixed by iconv or be autodetected by the server.

You can find details about the subject in the chapter 21.2 Character Set 
Support of the server documentation.

Best regards

Am Dienstag, 15. Juli 2008 16:14:25 schrieb Carol Walter:
> Hello,
> I have some databases that use SQL ASCII or Latin1 encoding that need
> to be UTF8.  When I have drop the database and recreated it with the
> correct encoding I get errors in restoring the data.  How is this done?
> Carol

In response to

pgsql-admin by date

Next:From: samantha mahindrakarDate: 2008-07-15 17:54:00
Subject: Jobs using pgagent
Previous:From: Kevin GrittnerDate: 2008-07-15 17:24:10
Subject: Re: Backup and failover process

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group