Received: from mel.alcatel.fr (mel.alcatel.fr [212.208.74.132]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fASGNHm82041 for ; Wed, 28 Nov 2001 11:23:18 -0500 (EST) (envelope-from vincent.gaboriau@answare.fr) Received: from aifhs2.alcatel.fr (mailhub.alcatel.fr [155.132.180.80]) by mel.alcatel.fr (ALCANET) with ESMTP id fASGNM90004796 for ; Wed, 28 Nov 2001 17:23:22 +0100 Received: from frmail30.netfr.alcatel.fr (frmail30.netfr.alcatel.fr [155.132.182.163]) by aifhs2.alcatel.fr (ALCANET/SMTP2) with ESMTP id RAA03904 for ; Wed, 28 Nov 2001 17:22:53 +0100 (MET) Received: from answare.fr ([159.217.208.148]) by frmail30.netfr.alcatel.fr (Lotus Domino Release 5.0.6a) with ESMTP id 2001112817231944:2139 ; Wed, 28 Nov 2001 17:23:19 +0100 Message-ID: <3C050FAE.4273AE4B@answare.fr> Date: Wed, 28 Nov 2001 17:24:14 +0100 From: Vincent.Gaboriau@answare.fr Organization: Answare X-Mailer: Mozilla 4.75 [fr] (Windows NT 5.0; U) X-Accept-Language: fr MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: =?iso-8859-1?Q?=E9=E8=E0=EF=EE=F9?= Problem X-MIMETrack: Itemize by SMTP Server on FRMAIL30/FR/ALCATEL(Release 5.0.6a |January 17, 2001) at 11/28/2001 17:23:19, Serialize by Router on FRMAIL30/FR/ALCATEL(Release 5.0.6a |January 17, 2001) at 11/28/2001 17:23:21 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id fASGWj582407 X-Archive-Number: 200111/150 X-Sequence-Number: 2675 Hi all, I had curious problem with the characters like " йиапощ... " (refer to my first mail "[ADMIN] character sequence problem" for more information). My database was encoding with UNICODE. I have created another one with LATIN1 encoding, and I have'nt anymore those problems! Can any one explain to me why? Which encoding is used in postgres when you say UNICODE? UTF-8? I thought that UNICODE is knowing all the characters! Thanks, Vincent.