Re: Postgresql, unicode and umlauts

Dear Sir,

I have also submitted following (in slightly different manner to the
postgresql newsgroup comp.databases.postgresql.general on
news.postgresql.org. The posting there is of 31.12.2002 02:02 and is titled
"Postgresql 7.2.1 and umlauts".
So far I have received no reply and since I saw that you are the person that
did the coding for my problem, I write directly to you:

I have a Linux Box running Postgresql 7.2.1 and php 4.2.1+apache-ssl
1.3.26+1.48.

I have set up a small php form that inserts something in a postgres database
called "test" in a table called "guestbook".
Client and Database Encoding is set to UNICODE, but whenever a user submits
an umlaut character (for example: ö,ä,ü or sharp-s (ß)) then I get an error
message that it is an invalid unicode character sequence:
Warning: PostgreSQL query failed: ERROR: Invalid UNICODE character sequence
found (0xe40000) in /var/www/dc+da/em.inc on line 63
(thats the error message for umlaut-a)

In the Warning message for umlaut-o there is also a spelling mistake:
Warning: PostgreSQL query failed: ERROR: Unicode >= 0x10000 is not supoorted
in /var/www/dc+da/em.inc on line 63
(note supoorted instead of supported)

I have tried to change the encoding with php by setting pg_setclientencoding
or using mp_convert_encoding, but it did not work. Either the error message
came up, or there were strange or no characters written into the database.

How is it possible to write umlaut characters into a postgresql database?
A friend of mine running postgresql 7.2.2 on FreeBSD also tried and failed
too. He tried not only with php but with perl aswell.

Here is the list of databases:
psql -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
template0 | postgres | UNICODE
template1 | postgres | UNICODE
test | ata | UNICODE
(3 rows)

Here is the the SQL statement that creates the table:
CREATE TABLE guestbook (
postid SERIAL PRIMARY KEY,
name TEXT NOT NULL,
email TEXT,
title TEXT NOT NULL,
message TEXT NOT NULL,
posted TIMESTAMP DEFAULT 'now'
);

Here is postgresql version information:
psql -V
psql (PostgreSQL) 7.2.1
contains support for: readline, history, multibyte
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996, Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

the "problematic" line 63 of my php script looks as following:
$result = pg_exec($database,"INSERT INTO guestbook ...");

The script works if you do not put in any umlaut characters.

Sincerely,
Ata