Postgres Pro
Downloads
Home   >   mailing lists

Re: Covert database from ASCII to UTF-8 - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: Covert database from ASCII to UTF-8
Date
Msg-id m2wrkcf0aq.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Covert database from ASCII to UTF-8  (Jeff Amiel <becauseimjeff@yahoo.com>)
List pgsql-general
Tree view 
Jeff Amiel <becauseimjeff@yahoo.com> writes:
> It's come time to bite the bullet and convert a half-terraybyte database
> from ASCII to UTF8.  Have gone through a bit of effort to track down the
> unclean ascii text and repair it but would like to avoid the outage of a
> many-many hour dump-restore.

Those blog articles of mine might be of interest to you:

  http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_1.html
  http://tapoueh.org/articles/blog/_Getting_out_of_SQL_ASCII,_part_2.html

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Finding Errors in .csv Input Data
Next
From: Dimitri Fontaine
Date:
Subject: Re: FTS and words near one another