From: Ivo Rossacher <rossacher@bluewin.ch>
To: pgsql-admin@postgresql.org
Subject: Re: Migration from ASCII to UTF8
Date: Fri, 30 May 2008 19:46:32 +0200
Message-ID: <200805301946.32626.rossacher@bluewin.ch> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760CDDD99@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE8760CDDD99@SAB-FENWICK.sab.uiuc.edu>
ASCII character encoding means that the database does not care about the
encoding. So it is the responsibility of the programs you use, to use the
correct encoding for your application. So you need to know the used encoding
of your applications/data in your database. Then you can convert a text
backup by recode, iconv or anything like that to utf8. You should be able to
restore the corrected dump into a utf8 database. If your applications used
different encodings you have to fix this somehow by hand first.
In chapter 22 of the manual you can find more details about encodings.
Best regards
Ivo
Am Freitag, 30. Mai 2008 15:45:25 schrieb Campbell, Lance:
> I have a database that is in ASCII character encoding. How do I go
> about migrating it to UTF8?
>
>
>
> Thanks,
>
>
>
> Lance Campbell
>
> Project Manager/Software Architect
>
> Web Services at Public Affairs
>
> University of Illinois
>
> 217.333.0382
>
> http://webservices.uiuc.edu
>
> My e-mail address has changed to lance@illinois.edu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rossacher@bluewin.ch
Subject: Re: Migration from ASCII to UTF8
In-Reply-To: <200805301946.32626.rossacher@bluewin.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox