Skip site navigation (1) Skip section navigation (2)

Re: Invalid EUC_TW character sequence found

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 (view raw or flat)
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




In response to

Responses

pgsql-bugs by date

Next:From: Tatsuo IshiiDate: 2002-06-26 03:42:06
Subject: Re: Invalid EUC_TW character sequence found
Previous:From: Gordon LukDate: 2002-06-26 02:32:18
Subject: [Fwd: [GENERAL] [Please Help!!!!!!!!] Problem in Chinese (Big5)!!! Version 7.2.1 (come with Redhat 7.3)]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group