Re: MySQL JDBC driver problem

2003-03-17 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Shu-Ping Lin wrote:
 Hi, How are you?
 
 I have a problem to jdbc driver. My paltform is win2000 professional and
 MySQL Server's version is 3.23.55.
 
 I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some
 problems to this jdbc driver version.
 
 When i use some method about setting or getting String such like
 setString(1,kkk) in PrepareStatement or
 
 getTableName(1) in ResultMetaData, these methods do not work correctly. I
 can not get correct String by some getting String method,
 
 so do others setting String method. Strange, when i change JDBC driver to
 mysql-connector-java-2.0.14.jar everything is right.
 
 All programs work, so i report this problem to you and wish to find the
 reason of causing the problem.
 
 Thanks!


My guess is that your JVM platform encoding is multibyte, while the one
in MySQL is not. You will need to upgrade to a nightly snapshot of
Connector/J 3.0 for the fix to this (until 3.0.7 is released). Please
see http://mmmysql.sourceforge.net/snapshots/stable/

-Mark


- -- 
MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__ 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+dc6ytvXNTca6JD8RAvlbAJ9lWuibvd4mAfSqudHfMQDM6bXc1ACdFpD7
lrjMGVMVDae+1BdDaMkmX6U=
=uWfH
-END PGP SIGNATURE-


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



MySQL JDBC driver problem

2003-03-16 Thread Shu-Ping Lin
Hi, How are you?

I have a problem to jdbc driver. My paltform is win2000 professional and
MySQL Server's version is 3.23.55.

I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some
problems to this jdbc driver version.

When i use some method about setting or getting String such like
setString(1,kkk) in PrepareStatement or

getTableName(1) in ResultMetaData, these methods do not work correctly. I
can not get correct String by some getting String method,

so do others setting String method. Strange, when i change JDBC driver to
mysql-connector-java-2.0.14.jar everything is right.

All programs work, so i report this problem to you and wish to find the
reason of causing the problem.

Thanks!



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php