X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 95BD1476392 for ; Mon, 5 May 2003 11:20:24 -0400 (EDT) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 03D8A47641B for ; Mon, 5 May 2003 11:20:20 -0400 (EDT) Received: from matrix.gatewaynet.com (localhost [127.0.0.1]) by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h45KO51s018038; Mon, 5 May 2003 18:24:05 -0200 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id h45KO5MD018034; Mon, 5 May 2003 18:24:05 -0200 Date: Mon, 5 May 2003 18:24:05 -0200 (GMT+2) From: Achilleus Mantzios To: Ian Barwick Cc: Marco Roda , Subject: Re: UNICODE and SQL In-Reply-To: <200305051637.19406.Ian Barwick <>> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-32.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, QUOTE_TWICE_1,REPLY_WITH_QUOTES,USER_AGENT_PINE autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/56 X-Sequence-Number: 13221 On Mon, 5 May 2003, Ian Barwick wrote: > On Monday 05 May 2003 15:34, Marco Roda wrote: > > Hallo, > > > > I need to use SQL to insert some language specific characters into tabl= es. > > In particular I am using German and Croatian specific characters. The > > database is created with UNICODE encoding. > > For instance, when trying to run from psql: > > > > INSERT INTO test VALUES (1,'Urlaubslite f=FCr n=E4chstes Jahr'); > > > > I get the following error: > > > > ERROR: Invalid UNICODE character sequence found (0xfc7220) > > > > because of '=FC' and '=E4'. >=20 > What is your psql client encoding set to? Possibly you need > to set it to LATIN1. The UTF8 version of Latin1 is Latin1 itself, but german and iso8859-2 serbocroatian are non Latin1 (high ASCII) chars. >=20 > Ian Barwick > barwick@gmx.net >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? >=20 > http://www.postgresql.org/docs/faqs/FAQ.html >=20 --=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt Nikis 4, Glyfada Athens 16610 Greece tel: +30-210-8981112 fax: +30-210-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr