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

From Scott Marlowe
Subject Re: Posgresql to MSsql encoding problem
Date
Msg-id dcc563d10910090802o56bc6c3ahe5a093031cd59be2@mail.gmail.com
Whole thread Raw
In response to Re: Posgresql to MSsql encoding problem  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Responses Re: Posgresql to MSsql encoding problem
List pgsql-general
On Fri, Oct 9, 2009 at 8:49 AM, Pedro Doria Meunier
<pdoria@netmadeira.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Sam,
> Thanks for your answer! :)
>
> The matter of fact is that the script itself is the connected client
> where the postgresql server is concerned.
>
> It then connects to another server (the M$SQL one) and, on a row
> basis, inserts data coming from the aforementioned connection...
>
> So, to all effects, the script is *the* client... :)

It's a php script, right?  Just issue a pg_query("set client encoding
yadayada;") at the beginning.

pgsql-general by date:

Previous
From: Pedro Doria Meunier
Date:
Subject: Re: Posgresql to MSsql encoding problem
Next
From: "Joshua D. Drake"
Date:
Subject: Re: interface for "non-SQL people"