7 messages in com.mysql.lists.gui-toolsRe: int length default of 11
FromSent OnAttachments
Travis Reeder14 May 2004 00:01 
Adam Hooper14 May 2004 04:13 
Travis Reeder14 May 2004 08:41 
Adam Hooper14 May 2004 08:51 
Travis Reeder14 May 2004 09:09 
Adam Hooper14 May 2004 09:12 
Travis Reeder14 May 2004 09:32 
Subject:Re: int length default of 11
From:Adam Hooper (ada@densi.com)
Date:05/14/2004 08:51:49 AM
List:com.mysql.lists.gui-tools

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Travis Reeder wrote:

| I don't thin kit is the range of 11 digits. What happened was on an int | autoincrement column, it would not take anymore inserts saying something | about invalid value or range or something, so I changed the 11 to 15 and | it started taking new values. It is currently at: | | 12266715 | | 11 would not accept that high of a number which is only 8 digits and not | even close to the 4 bytes of an int. So why would changing the length | to 15 make it start working and why would it stop taking values at 11?

Here are some possibilities, in order of least to most likely:

- - A bug in the MySQL server - - It wasn't "11" before, but MySQLCC was displaying "11" anyway (bug in MySQLCC) - - It wasn't an int before - - There's something else you haven't noticed

I assure you, the "11" means "number of characters".

iD8DBQFApOsrD7ySSW2J9egRAtvJAKCclchVrdPww4Jn1bLFzjIhB7OcjgCcDMfo LVi6TmyP0o4o93O0ie0uovY= =fIQj -----END PGP SIGNATURE-----