Invalid EUC_JP char seq bug?

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Invalid EUC_JP char seq bug?
Date: 2003-07-02 00:34:15
Message-ID: 3F022887.10908@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I am using PHP with postgreSQL and I have been getting a few rare errors
while trying to do selects on a table containing EUC_JP text.

I thought it was a bug with PHP not recognizing a string as invalid
EUC_JP characters and wrote up a bug report but the PHP developers
assure me that the string that is generating the error is a valid EUC_JP
string (I don't know anything about character encodings so I am taking
them at their word and the fact that the string displays fine in my
browser as EUC_JP lends me to suspect they might be right).

The offending string is url encoded as such:

words=%8f%ac%90%ec%96%be%93%fa%8d%81

When I try and do a SELECT I get the following error:

select id from products where name like '??????'
Query failed: ERROR: Invalid EUC_JP character sequence found (0x8100)

(Where did the 0x00 come from??)

Can someone let me know if this truly is a bug in postgres?

Thanks,

Jean-Christian Imbeault

PS I have also had the error pop up with this string:

search_words=%B7%F6%BA%7E
select id from products where name like '??~'
Query failed: ERROR: Invalid EUC_JP character sequence found (0xba7e)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2003-07-02 02:20:17 Re: Invalid EUC_JP char seq bug?
Previous Message Markus Bertheau 2003-07-01 22:37:13 Re: Problem with "z_" in Unicode-DB