From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Ian Barwick <barwick@gmx.net>
Cc: Marco Roda <MarcoRoda@amdosoft.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: UNICODE and SQL
Date: Mon, 5 May 2003 18:24:05 -0200 (GMT+2)
Message-ID: <Pine.LNX.4.44.0305051822250.17972-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <200305051637.19406.Ian Barwick <>
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 tables.
> > 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ür nächstes Jahr');
> >
> > I get the following error:
> >
> > ERROR: Invalid UNICODE character sequence found (0xfc7220)
> >
> > because of 'ü' and 'ä'.
>
> 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.
>
> Ian Barwick
> barwick@gmx.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
==================================================================
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, barwick@gmx.net, MarcoRoda@amdosoft.com
Subject: Re: UNICODE and SQL
In-Reply-To: <Pine.LNX.4.44.0305051822250.17972-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox