Re: Posgresql to MSsql encoding problem - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Posgresql to MSsql encoding problem
Date
Msg-id b42b73150910090611h306942e1jefe8de179e31a34c@mail.gmail.com
Whole thread Raw
In response to Posgresql to MSsql encoding problem  (Pedro Doria Meunier <pdoria@netmadeira.com>)
List pgsql-general
On Fri, Oct 9, 2009 at 6:39 AM, Pedro Doria Meunier
<pdoria@netmadeira.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi All,
>
> I have this PHP script that simply dumps (inserts) data from a
> Postgresql server to a customer's M$SQL server.
>
> The database in the PGSQL server is UTF-8 encoded where the M$SQL
> database uses LATIN1.

why can't you set the client encoding?  php should be able to handle
latin1 and send it to mssql right?  if you can't do it automatically
there is always iconv.

merlin

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Best data type to use for sales tax percent
Next
From: Sam Mason
Date:
Subject: Re: Posgresql to MSsql encoding problem