Bug #8175 connector/J 4.1.6 handles incorrectly characters like: òàùèé

• Submitted: 28 Jan 2005 9:18
• Modified: 5 Feb 2005 16:21
• Reporter: Alessandro Polverini
• Status: Can't repeat
• Category: Connector / J
• Severity: S2 (Serious)
• Version: 4.1.6 and 4.2.0
• OS: Linux (Linux)
• CPU Architecture: Any

[28 Jan 2005 9:18] Alessandro Polverini

Description:
Hello,
I'm developing a little application with Tomcat 5.0.28, MyFaces 1.0.8 and mysql 4.0.23.
Using Connector/J 4.0.16 everything works fine like usual.
Following recent announce of newer connector, I tried to upgrade but I have big problems on italian letters with accent marks like "òàùèé".
The problems are:
- I can't read correctly any more old records on the DB with those letters (letters are garbled)
- New records are written badly (looking at the records with phpmyadmin shows garbled letters)
- reading newly saved records show garbled letters again, even if differents from first case

I tried both versions 4.1.6 and 4.2.0 with same results.

Given that, upgrade is completely impossible for me :(

Alex

How to repeat:
test1: read an old record with accent marks
test2: write a new record and read it back

In both cases the output is wrong on the letters with accent marks.

Suggested fix:
Revert to old character encoding/decoding if using non-UTF8 tables like in mysql 4.0.x?

[31 Jan 2005 14:30] Alessandro Polverini

Sorry I wrote bogus version in :
"I tried both versions 4.1.6 and 4.2.0 with same results."
I meant of course 3.1.6 and 3.2.0.