Character problems

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Character problems
Date: 2002-01-21 13:20:38
Message-ID: 200201211325.g0LDPpd10037@server9.telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have a problem with inserting/updating "strange" characters. I can only use
strange characters at the beginning of a string. The select statement has'nt
this problem.

Is this a bug or am i doing something wrong ?

Regards,
Ferdinand

Example:

db=> select '\353x';
?column?
----------
ëx
(1 row)

db=> select 'xx\353x';
?column?
----------
xxëx
(1 row)

db=>
db=> insert into x values ('\353x');
INSERT 4284014 1
db=> insert into x values ('xx\353x');
INSERT 4284015 1
db=> select * from x;
t
-----
ëx
x
(2 rows)

db=>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-01-21 13:33:04 Re: Performance
Previous Message Martins Zarins 2002-01-21 08:04:53 Re: Performance