Re: get rid of SQL_ASCII?

Joshua D. Drake wrote:
> 
> On 09/05/2013 09:42 AM, Josh Berkus wrote:

> >>Other ideas?  Are there legitimate uses for SQL_ASCII?
> >
> >Migrating from MySQL.  We've had some projects where we couldn't fix
> >MySQL's non-enforcement text garbage, and had to use SQL_ASCII on the
> >receiving side.  If it hadn't been available, the user would have given
> >up on Postgres.
> 
> iconv?

Command Prompt helped a customer normalize encodings in their data,
which was a mixture of Latin1 and UTF8.  PGLoader was used for this, in
two stages; the first run in UTF8 saved the rejected data to a file
which was loaded in the second run as Latin1.  This worked like a charm.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services