List:MySQL and Java« Previous MessageNext Message »
From:Mark Matthews Date:May 30 2003 10:05pm
Subject:Re: Data type for int
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Twibell, Cory L wrote:

> Mark,
>
> Yes, the column is INT UNSIGNED.
[snip]

No problem. INT UNSIGNED values can potentially be larger than a Java
int, that's why they map to a Java long in the JDBC driver (4294967294
is larger than 2147483647, which is the maximum value for an 'int' in Java)

	-Mark


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

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+19WrtvXNTca6JD8RAnZTAKCDS+nO/HUTwsqNua69VMtNIPqp7QCguV3o
Ra+KWRDwJpTdx24e/uGM8XM=
=sUWp
-----END PGP SIGNATURE-----

Thread
Data type for intCory L Twibell30 May
  • Re: Data type for intMark Matthews30 May
Re: Data type for intMark Matthews30 May
Re: Data type for intMark Matthews31 May