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=# insert into a (aa) values (自由);
ERROR: column "自由" does not exist
LINE 1: insert into a (aa) values (自由);
a=# select * from a;
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.
In SQL when you mean a string you usually have to put it between ' characters, e.g.
INSERT INTO a (aa) VALUES ('a string')
HP ProCurve 1800-24G, Phenom 9750, Dual Opteron 265, AMD64 3000+,
Dual P3-800, eMac G4 1.0GHz, Sun Blade 150, Alpha PWS 433 and more ...
|Thread||Thread Starter||Forum||Replies||Last Post|
|HOWTO: ISO-8859-1 Character Set on NetBSD||JMJ_coder||Guides||0||24th February 2009 11:53 PM|
|Big5 Character Set in Apache problem after upgrade to 6.4||paul-lkw||FreeBSD Installation and Upgrading||0||23rd February 2009 08:20 AM|
|Do you need hard link for PostgreSQL?||Sunnz||General software and network||5||26th October 2008 06:07 PM|
|[FreeBSD] which version of PostgreSQL?||MacApp||FreeBSD Ports and Packages||8||12th July 2008 09:25 AM|
|PostgreSql rc.d script||fridder||FreeBSD Ports and Packages||1||1st July 2008 01:12 AM|