Re: Bug in J/Connector 3.0.1 beta

Ok, more clearly:

You have a SERIOUS bug in connector, version 3.0.1 beta that was
not present in 3.0.0 beta.

The following step illustrates the problem:

1. use JDBC to connect to the database with default character mapping.
2. insert a string to any table column with the value of "åäö".
3. select the inserted row and use result set with getString to
read the written string.
4. compare the java strings with the String.equals method.
5. They are not equal! In fact, any non US-ASCII characters are
scrambled in this proceedure. In version 3.0.0 they are identical however.
6. If you try to explicity specify the character encoding it will
fail for any encoding not equal to "US-ASCII" in version 3.0.1 but
it works in version 3.0.0.

Regards,
Jarl Fransson


2002-11-08 00:04:03, bugs@lists.mysql.com wrote:

>Your message cannot be posted to bugs@lists.mysql.com because it did not
>follow the format expected by our spam/off-topic filter. To this list we
>accept only repeatable bugs reports, meaning that you can describe a
>set of steps we can follow to repeat the bug on our systems.
>
>If you are having problems with MySQL but are unable to provide the required
>description, and have not purchased a support contract from MySQL AB,
>you should send your message to mysql@lists.mysql.com and possibly one of our
>knowledgable users or developers will help you. However, we do not guarantee
>that every message on mysql@lists.mysql.com will be answered. We can afford
>to provide free code, but unfortunately, we cannot afford to provide
>guaranteed free support on top of that. We do, nevertheless, fix our bugs
>regardless of who reports them and whose systems they affect, and will
>investigate your problem if you can prove to us with a test case that the
>error is in our code and not yours.
>
>If you have purchased a support contract from MySQL AB, you should follow
>the standard support request procedure to report this problem. Support
>contracts are available at https://order.mysql.com/.
>
>If you are able to describe how we can repeat the problem, include the string
>"How-To-Repeat:" in the body of your message, followed by the detailed
>description of what we need to do to make it happen, and our filter will
>accept your message. If you use mysqlbug script, which comes with the MySQL
>distribution, to post the message, it will be automatically accepted.
>
>You have written the following:
>
>---start of your message----
>There is a problem in 3.0.1 beta with character encodings.
>After spending a few hours the only way I could solve this
>was to roll back to 3.0.0.
>
>When using 3.0.1 with default settings international characters
>get scrambled when written and read back to the database.
>When you explicitly set using useUnicode=true the ONLY character encoding
>that is accepted is US-ASCII. I have tried all of the following
>UTF-8, ISO-8859-1, ISO-LATIN-1 and they all give java exception
>saying unsupported character encoding. These all work for beta 3.0.0.
>
>If I specify useUnicode=false I can set the encodings but the
>characters still get scrambled in the database.
>
>Regards,
>Jarl Fransson
>
>
>
>---end of your message-------
>
>MySQL Development Team
>




------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12910@lists.mysql.com
To unsubscribe, e-mail