UNICODE and SQL

From: "Marco Roda" <MarcoRoda(at)amdosoft(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: UNICODE and SQL
Date: 2003-05-05 13:34:21
Message-ID: 001401c3130b$0996ed80$0301a8c0@amdosoft.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 'ä'.

How to do it?
Thanks,
Marco Roda

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2003-05-05 14:37:54 Re: UNICODE and SQL
Previous Message Rod Taylor 2003-05-05 13:33:05 Re: Indices are not used by the optimizer