7 messages in com.mysql.lists.gui-toolsRe: int length default of 11| From | Sent On | Attachments |
|---|---|---|
| Travis Reeder | 14 May 2004 00:01 | |
| Adam Hooper | 14 May 2004 04:13 | |
| Travis Reeder | 14 May 2004 08:41 | |
| Adam Hooper | 14 May 2004 08:51 | |
| Travis Reeder | 14 May 2004 09:09 | |
| Adam Hooper | 14 May 2004 09:12 | |
| Travis Reeder | 14 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".
- -- Adam Hooper ada...@densi.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFApOsrD7ySSW2J9egRAtvJAKCclchVrdPww4Jn1bLFzjIhB7OcjgCcDMfo LVi6TmyP0o4o93O0ie0uovY= =fIQj -----END PGP SIGNATURE-----




