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)
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 |