- 论坛徽章:
- 0
|
環境: OSX 10.6.2 英文
下載POSTGRESQL DMG版, 用Locale= default, 及Locale=zh_TW, 兩個方法安裝過, 也輸入中文不能
d1=# SHOW client_encoding;
client_encoding
-----------------
EUC_TW
./psql -l -U postgres
Password for user postgres:
List of databases
Name | Owner | Encoding | Collation | Ctype | Access privileges
-----------+----------+----------+-----------+-------+-----------------------
d1 | postgres | UTF8 | zh_TW | zh_TW |
d2 | postgres | UTF8 | zh_TW | zh_TW |
postgres | postgres | UTF8 | zh_TW | zh_TW |
template0 | postgres | UTF8 | zh_TW | zh_TW | =c/postgres
: postgres=CTc/postgres
template1 | postgres | UTF8 | zh_TW | zh_TW | =c/postgres
: postgres=CTc/postgres
(5 rows)
d1=# isnert into tbl1 values ("允许你动态修改客户端编");
ERROR: invalid byte sequence for encoding "UTF8": 0xd4ca
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
希望有高手給在下賜教. |
|