Hi, Roland

  Try my JDBC Driver.

   http://www.t3-jpn.com/jdbc/jdbcmysql.html
   http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip

Thanks.

Roland wrote:
> 
>  Hello,
>  I'm losing precision when I send a double to a mysql database from a Java
>  program trough JDBC.
>  Code:
>  stmt.setDouble(i+3,((Double)value).doubleValue());
> 
>  I use a prepared statement.
>  Now, if I print out the double in java before sending it to the MySql
>  database this is what it looks like:
>  1277.00143924408
>  (11 decimal digits)
> 
>  When I look in the database, this is what the value looks like:
>  1277.00143924
>  (8 decimal digits)

  <snip>

-- 
TAKAHASHI, Tomohiro

---------------------------------------------------------------------
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

Reply via email to