Received: from mailhub7.isdnet.net (mailhub7.isdnet.net [195.154.209.27]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9SDciP31838 for ; Sun, 28 Oct 2001 08:38:45 -0500 (EST) (envelope-from jm.poure@freesurf.fr) Received: from station ([195.154.28.3]) by mailhub7.isdnet.net (8.9.3/8.9.3) with ESMTP id OAA62895; Sun, 28 Oct 2001 14:34:52 +0100 (CET) Message-Id: <4.2.0.58.20011028140833.00d13490@pop.freesurf.fr> X-Sender: jm.poure@pop.freesurf.fr X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 Date: Sun, 28 Oct 2001 14:34:49 +0100 To: Marko Kreen From: Jean-Michel POURE Subject: Re: UNICODE Cc: pgsql-hackers@postgresql.org In-Reply-To: <20011028140547.A15516@l-t.ee> References: <4.2.0.58.20011028121057.00d1a100@pop.freesurf.fr> <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> <4.2.0.58.20011028085953.00cfa740@pop.freesurf.fr> <4.2.0.58.20011028121057.00d1a100@pop.freesurf.fr> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f9SDpYM34406 X-Archive-Number: 200110/987 X-Sequence-Number: 14709 >psql uses your input literally - so is your console/xterm in >UNICODE/UTF8? Client: \encoding returns 'UNICODE'. Server: \list show databases. All databases are UNICODE (except TEMPLATE0 and TEMPLATE1 which are ASCII of course). I use a Mandrake 8.1 distribution and think my console is UNICODE. > > As for me, I typed INSERT INTO source_content VALUES ('Permis de conduire > > accepté') in Psql. >As I said - psql does not do any conversion. The faulty query is: INSERT INTO test (source_content) VALUES ('Permis de conduire accepté'); I just can't believe that Psql is not UTF-8 compatible. It seems unreal as Psql is PostgreSQL #1 helper application. Should I use PostgreSQL MULE encoding to have automatic trans coding. What are the guidelines, I am completely lost. > > Psql does not insert the data and I have to kill it manually. Can you > > reproduce this? >No. If it hangs this is serious problem. Or did you simply >forgot final ';' ? It btw does not seem valid sql to me, >considering you previously provided table structure. Is it possible that my database is corrupted? I have used pg_dump several times to dump data from production server to development servers and conversely. Does pg_dump produce UTF8 output? What are the guidelines when using UTF-8: forget psql and pg_dump? >In the end: are the strings/queries you give to psql/pg_exec >UTF-8 - this is now main thing, as you have _configured_ >everything correctly. Everything is configured correctly server-side (PostgreSQL, Psql). Thank you very much for your support Marko, Best regards, Jean-Michel