From: | Gene Leung <gene(at)regaltronic(dot)com> |
---|---|
To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | pgsql-bugs(at)postgresql(dot)org, gordon(at)gforce(dot)ods(dot)org |
Subject: | Re: Invalid EUC_TW character sequence found |
Date: | 2002-06-26 03:30:19 |
Message-ID: | 3D19354B.E13E40AE@regaltronic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2002-06-26 03:42:06 | Re: Invalid EUC_TW character sequence found |
Previous Message | Gordon Luk | 2002-06-26 02:32:18 | [Fwd: [GENERAL] [Please Help!!!!!!!!] Problem in Chinese (Big5)!!! Version 7.2.1 (come with Redhat 7.3)] |