Postgresql 7.2.1 and umlauts

From: "Atahualpa Jones" <NOatahualpaSPAM(at)gmx(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql 7.2.1 and umlauts
Date: 2002-12-31 01:02:31
Message-ID: auqqbc$2no5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

psql -V
psql (PostgreSQL) 7.2.1
contains support for: readline, history, multibyte

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

test=# show client_encoding;
NOTICE: Current client encoding is 'UNICODE'

Yet it is impossible to insert an umlaut into this database.

I have created a HTML form and a php function (4.2.1) that stores the
contents of this form in database "test" (in a table called guestbook).
Whenever I type in an umlaut character I get following error message:
for umlaut-a I get: Warning: PostgreSQL query failed: ERROR: Invalid
UNICODE character sequence found (0xe40000) in /var/www/dc+da/em.inc on line
63

for umlaut-u I get: Warning: PostgreSQL query failed: ERROR: Invalid
UNICODE character sequence found (0xfc0000) in /var/www/dc+da/em.inc on line
63

for umlaut-o I get: Warning: PostgreSQL query failed: ERROR: Unicode >=
0x10000 is not supoorted in /var/www/dc+da/em.inc on line 63

for a sharp-s (szlig in html specialchar notation) I get: Warning:
PostgreSQL query failed: ERROR: Invalid UNICODE character sequence found
(0xdf00) in /var/www/dc+da/em.inc on line 63

Also notice the spelling mistake in the output for umlaut-o: supoorted
instead of supported.

line 63 is very simple:
$result = pg_exec($database,"INSERT INTO guestbook ....");

I have tried some php functions to change the character encoding
mp_convert_encoding for example or pg_setclientencoding but nothing helped.
Either the error message was shown or the wrong character is inserted into
the database or nothing is inserted.
This shouldnt be with unicode shouldnt it?

So how do I insert umlaut characters in postgresql version 7.2.1 and higher?

TIA,
Atahualpa

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2002-12-31 01:13:36 Re: lock table question
Previous Message Nigel J. Andrews 2002-12-30 23:59:18 Re: pg and transactions