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" ("name") VALUES ('¦r')
2002-06-26 11:14:42 -
*******************************************************************
2002-06-26 11:14:42 - Error
2002-06-26 11:14:42 -
*******************************************************************
2002-06-26 11:14:42 - Error in pgAdmin II:frmSQLOutput.cmdSave_Click:
-2147467259 - ERROR: Invalid EUC_TW character sequence found (0xa672)
2002-06-26 11:14:42 - Windows Version: Windows 2000 v5.0 build 2195 Service Pack
2
2002-06-26 11:14:42 - pgSchema Version: 1.2.0
2002-06-26 11:14:42 - MDAC Version: 2.5
2002-06-26 11:14:42 - DBMS Version: 07.02.0001 PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
2002-06-26 11:14:42 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=sql;PORT=5432;UID=harry;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"
From the above, I inserted three rows to the table using the pgAdmin II , the
first two without any problem except the last one. I even confirm these input
with the psql on the server side. Same result applies the above problem.
To me, the third insert is a character that display correctly in my application,
I do not see any problem. And I do not know and can not tell how to check that
'¦r' is not a correct ECU_TW character. Please give me some hint for checking,
thanks!!
Best Regards
Gene Leung
Tatsuo Ishii wrote:
> > The second way to confirm version 7.2.1 can not accept chinese input is to
> > create a new database with the following command:
> >
> > CREATE DATABASE "test" WITH ENCODING = 'EUC_TW';
> >
> > then create table site (name varchar(50)); and insert data directly with
> > pgAdmin II, it gives error as follows:
> >
> > -2147467259 - ERROR: Invalid EUC_TW character sequence found (0xa672)
>
> 0xa672 cannot be a correct EUC_TW character. Check your application.
> --
> Tatsuo Ishii
