Re: Posgresql to MSsql encoding problem

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.