Postgres - Unicode - Problem

[Andreas Tille <tillea@rki.de>]

Hi,

I tried a little script under testing (PostgreSQL 7.3.2r1-5):

#!/bin/sh
dbtocreate=unicodetestdb

psql template1 <<...
CREATE DATABASE $dbtocreate ENCODING 'unicode';
...

psql $dbtocreate <<...
CREATE TABLE i18n_translations (
	lang varchar(10),
	orig text,
	trans text
);
INSERT INTO i18n_translations(lang, orig, trans) values
	('de_DE', 'public', 'öffentlich');
...

The last line fails and I get the following output if I run this script:

CREATE DATABASE
CREATE TABLE
ERROR:  Unicode >= 0x10000 is not supported

Could anybody enlighten me how to use German Umlauts with UNICODE?

Kind regards

         Andreas.