Recently, I have installed the version 7.2.1 to my Redhat 6.1 server with the following configure:
./configure --prefix=/usr/local/pgsql --enable-multibyte=EUC_TW --with-perl --with-python --with-tcl --enable-odbc After the installation, I have tried to restore some of my old databases from version 7.0.2 but in vain owing to invalid character found. Then I have tried to input some chinese character (big 5) directly, It gave me some errors as shown below from the pgAdmin II: 2002-06-25 17:20:13 - SQL (AccessControl): UPDATE "site" SET "cname" = '» ´ä ¦r' WHERE "siteid" = '001' AND "name" = 'this is HK' AND "cname" = '» ´ä' 2002-06-25 17:20:13 - ******************************************************************* 2002-06-25 17:20:13 - Error 2002-06-25 17:20:13 - ******************************************************************* 2002-06-25 17:20:13 - Error in pgAdmin II:frmSQLOutput.cmdSave_Click: -2147467259 - ERROR: Invalid EUC_TW character sequence found (0xa672) If there is any compatibility issue between the old version and the new one. Best Regards Gene Leung ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html