Postgres Pro
Downloads
Home   >   mailing lists

Re: converting databases form SQL_ASCII to UTF8 - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: converting databases form SQL_ASCII to UTF8
Date
Msg-id m28vury1ln.fsf@2ndQuadrant.fr
Whole thread Raw
In response to converting databases form SQL_ASCII to UTF8  (Geoffrey Myers <lists@serioustechnology.com>)
List pgsql-general
Tree view 
Geoffrey Myers <lists@serioustechnology.com> writes:
> So, now the question is, is this effort even worth our effort?
> What is the harm in leaving our databases SQL_ASCII encoded?

You're declaring bankruptcy on being able to make any sense of the data
you stored.  Is that really what you think you need?

For converting, you might be interested into those two blog entries:

  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: Multiple instances with same version?
Next
From: Dimitri Fontaine
Date:
Subject: Re: Partitioning an existing table