Re: get rid of SQL_ASCII?

Поиск
Список
Период
Сортировка
Искать
От
ktm@rice.edu
Тема
Re: get rid of SQL_ASCII?
Дата
Msg-id
20130905172930.GD30496@aart.rice.edu
Ответ на
Re: get rid of SQL_ASCII? (Joshua D. Drake)
Список
Дерево обсуждения
get rid of SQL_ASCII? Peter Eisentraut <peter_e@gmx.net>
Re: get rid of SQL_ASCII? "ktm@rice.edu" <ktm@rice.edu>
Re: get rid of SQL_ASCII? Heikki Linnakangas <hlinnakangas@vmware.com>
Re: get rid of SQL_ASCII? Craig Ringer <craig@2ndquadrant.com>
Re: get rid of SQL_ASCII? Tom Lane <tgl@sss.pgh.pa.us>
Re: get rid of SQL_ASCII? Robert Haas <robertmhaas@gmail.com>
Re: get rid of SQL_ASCII? Kevin Grittner <kgrittn@ymail.com>
Re: get rid of SQL_ASCII? Florian Weimer <fweimer@redhat.com>
Re: get rid of SQL_ASCII? Merlin Moncure <mmoncure@gmail.com> 
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
В списке pgsql-hackers по дате отправления
Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: get rid of SQL_ASCII?
Следующее
От: Heikki Linnakangas
Дата:
FAQ