-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
charles lee wrote:
> Description:
> I create one table with one blob column,
> use jdbc to setBytes and getBytes to the column ,and
> found out the value i get from the table is not the same
> as what i had set into the table.(default charset is sjis)
>
> when i change the my.ini 's charset,do not use sjis, it works well,
> what i get is what i set.
>
> I think the blob is binary data ,should not change value with
> deferent charset.
You don't say what version of the JDBC driver you are using, but it
appears to be a very old one, as a bug on the client side was fixed a
few years back.
Please try Connector/J 3.0.4 from
http://www.mysql.com/products/connector-j/ and see if the bug still exists.
If you could also test if this happens with the MySQL command-line
client (mysql), that might isolate whether or not it is a server issue.
-Mark
query, sql
- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <mark@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+LLhDtvXNTca6JD8RAozTAKC3zYnm4O4c3w4u+LQpBXAOwo11aACgn7ev
yORfQmsxv3VqgxnrTYTwr0U=
=CkOK
-----END PGP SIGNATURE-----
