Ok, but problem is, when i try encode with unicode, it also reject me.... invalid UNICODE charater.... :-(Show me the entire error message please.
Ok... error like this...
ERROR : Invalid UNICODE character sequence found (0xe5a672)...
the input charater also "¤¤¤å¦r"....
O... you are right, i use Pgadmin II , and type SQL by hand ... and add the "set client_encoding to 'Big5';" before insert statement.... It WORK!!!! Thanks...Actually PostgreSQL does support Big5. To use Big5, set the client encoding to Big5 and set the server(DB) encoding to EUC_TW. PostgreSQL will take care of the conversion between Big5 and EUC_TW.There are several ways to set the client encoding to Big5: SQL: set client_encoding to 'Big5'; from psql: \encoding Big5 using environment variable: export PGCLIENTENCODING=Big5 (example for bash) Hope this helps, -- Tatsuo Ishii
Gordon
