Re: Posgresql to MSsql encoding problem

Поиск
Список
Период
Сортировка
От Leif B. Kristensen
Тема Re: Posgresql to MSsql encoding problem
Дата
Msg-id 200910091711.07755.leif@solumslekt.org
обсуждение исходный текст
Ответ на Re: Posgresql to MSsql encoding problem  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: what is the best way to concat fields that may contain null as if they were empty strings
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: array question