pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Migration from ASCII to UTF8
2+ messages / 2 participants
[nested] [flat]

* Migration from ASCII to UTF8
@ 2008-05-30 13:45 Campbell, Lance <lance@illinois.edu>
  2008-05-30 17:46 ` Re: Migration from ASCII to UTF8 Ivo Rossacher <rossacher@bluewin.ch>
  0 siblings, 1 reply; 2+ messages in thread

From: Campbell, Lance @ 2008-05-30 13:45 UTC (permalink / raw)
  To: pgsql-admin

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

 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Migration from ASCII to UTF8
  2008-05-30 13:45 Migration from ASCII to UTF8 Campbell, Lance <lance@illinois.edu>
@ 2008-05-30 17:46 ` Ivo Rossacher <rossacher@bluewin.ch>
  0 siblings, 0 replies; 2+ messages in thread

From: Ivo Rossacher @ 2008-05-30 17:46 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-05-30 17:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-30 13:45 Migration from ASCII to UTF8 Campbell, Lance <lance@illinois.edu>
2008-05-30 17:46 ` Ivo Rossacher <rossacher@bluewin.ch>

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