Re: UNICODE and SQL

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(at)gmx(dot)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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr