Re: return type for SUM(numeric-column) is String
Mark Matthews <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Amit M Bhosle wrote: > hi.. > > i'm using mysql server version 5.0.21-standard, and am seeing this > wierd behavior that SUM of a numeric column returns a java.lang.String > ! > > was wondering if anyone else has seen this behavior, and if this is > a known issue, with (hopefully) a workaround.. > > thanks.. > AB > Amit, What version of the JDBC driver are you using? The server _does_ tell the JDBC driver that it's a string (really!), but newer versions of the driver can sometimes figure out that you're not really looking at a string. -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFUVMktvXNTca6JD8RAiLCAJ94vOFsqrp1TO3v51lETEQVfz/fjwCfZimt tw6L247c/g/6KquzluWTSvA= =+LEZ -----END PGP SIGNATURE----- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]