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

From Leif B. Kristensen
Subject Re: Posgresql to MSsql encoding problem
Date
Msg-id 200910091711.07755.leif@solumslekt.org
Whole thread Raw
In response to Re: Posgresql to MSsql encoding problem  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Friday 9. October 2009, Scott Marlowe wrote:
>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.

PHP even has a special function for it:

pg_set_client_encoding($db, LATIN1);
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: what is the best way to concat fields that may contain null as if they were empty strings
Next
From: Raymond O'Donnell
Date:
Subject: Re: array question