Re: converting databases form SQL_ASCII to UTF8

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