Multi-byte character bug

From: "Richard So" <richso(at)i-cable(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Multi-byte character bug
Date: 2002-07-27 06:45:41
Message-ID: 000401c23539$39d0abe0$0a00a8c0@netrogen.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Two bugs has been found in the SQL parser and Multibyte char support:

1. “Problem connecting to database: java.sql.SQLException: ERROR:
Invalid EUC_TW character sequence found (0xb27a)” was reported in using
JDBC driver to insert record, similar error reported when using ODBC
driver and psql, since auto-conversion from client to server should
convert the charcter to a valid EUC_TW char, therefore this is a bug

2. inserting record with “餐” chinese char, the SQL parser
report something like ‘Problem connecting to database:
java.sql.SQLException: ERROR: parser: parse error at or near "4567891"’
(similar in jdbc and odbc), and the error “unterminated string” has
been reported when using psql.

I’ve found the problem exists since 7.1.x till 7.2.*.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Lockhart 2002-07-27 15:01:27 Re: Bug #717: timestamp is converted to timestamptz
Previous Message paviles 2002-07-27 05:09:55 Bug #722: SELECT FOR UPDATE bug