UNICODE and SQL - Mailing list pgsql-sql

From Marco Roda
Subject UNICODE and SQL
Date
Msg-id 001401c3130b$0996ed80$0301a8c0@amdosoft.local
Whole thread Raw
Responses Re: UNICODE and SQL  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: UNICODE and SQL  (Ian Barwick <barwick@gmx.net>)
List 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



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Best way to delete time stamped data?
Next
From: Rod Taylor
Date:
Subject: Re: Indices are not used by the optimizer