On Thu, Sep 05, 2013 at 09:53:18AM -0700, Joshua D. Drake wrote: > > On 09/05/2013 09:42 AM, Josh Berkus wrote: > > > >Peter, > > > >>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? >
Yes, you can use iconv but then you have to check that it generated values that do not break your system including the application logic. That can prove a major stumbling block to changing DBs. Regards, Ken -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers