Hi Tatsuoi,
Thanks for your quick response. Actually I tried both way (1. dump and
restore, 2. create a new database in version 7.2.1) but in vain.
The first way is to dump a database from 7.0.2 database containing EUC_TW
data
List of databases
Database| Owner | Encoding
--
Not all chinese characters can not be input to the application, only some of
them,
2002-06-26 11:12:32 - SQL (test): INSERT INTO "site" ("name") VALUES ('¬ü¥úµó')
2002-06-26 11:12:47 - SQL (test): INSERT INTO "site" ("name") VALUES ('¥«µó¥«')
2002-06-26 11:14:42 - SQL (test): INSERT INTO "site" (
> -2147467259 - ERROR: Invalid EUC_TW character sequence found (0xa672)
The error message says all. You had invalid data (maybe raw Big5
data?) in your database.
(1) If you are sure you have raw Big5 data in the old database,
convert them to EUC_TW then load them.
(2) If you have EUC_TW an
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 vers