John DeSoi wrote:
On Mar 16, 2005, at 9:34 AM, Miroslav Šulc wrote:
I have problem on one of our potentional client's linux server with data encoding. I have played with this for some time but with no success. Here is the problem:
Maybe try setting the client side encoding explicitly at the top of the dump file:
\encoding UNICODE
It should also be possible to set this in the psql command line if you don't want to modify the file.
The dump file already contains the encoding information as the first command:
SET client_encoding = 'UNICODE';
so I think this is sufficient. What is strange to me is that the communication is UNICODE -> UNICODE so for me it means "no conversion", but the result is different.
Miroslav
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:[EMAIL PROTECTED] title:CEO tel;work:+420 257 225 602 tel;cell:+420 603 711 413 x-mozilla-html:TRUE url:http://www.startnet.cz version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
