Re: Posgresql to MSsql encoding problem

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
Cc: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Posgresql to MSsql encoding problem
Date: 2009-10-09 13:11:11
Message-ID: b42b73150910090611h306942e1jefe8de179e31a34c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 9, 2009 at 6:39 AM, Pedro Doria Meunier
<pdoria(at)netmadeira(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-10-09 13:38:47 Re: Posgresql to MSsql encoding problem
Previous Message Rich Shepard 2009-10-09 12:45:02 Re: Best data type to use for sales tax percent