View Single Post
  #1   (View Single Post)  
Old 8th June 2008
gosha gosha is offline
Spam Deminer
 
Join Date: Jun 2008
Location: China
Posts: 256
Default postgresql chinese character problem

This is what I get if I try to insert values in chinese, although the database is created with -E utf8:

$ psql a
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

a=# \encoding
UTF8
a=# insert into a (aa) values (自由);
ERROR: column "自由" does not exist
LINE 1: insert into a (aa) values (自由);
^
a=# select * from a;
aa
----
1
2
3
4
5
6
(6 rows)

As you can see, I inserted some number values just to try if it worked. Only, it does not accept chinese. Any ideas? I'm running the package that comes with OpenBSD 4.3, running in Mlterm. Also see my thread in X11, for problems with character input.
Thank you
Reply With Quote