You wouldn't happen to be crossing an architecture boundary, would you? Say from a Macintosh client to a PC server, or a PC client to a Sun Server?
16777216 Decimal = 1000000 Hex which would make perfect sense if there was an 'endism' problem. Philip Molter wrote: > I have a 3.23.45 database running with InnoDB tables. When I do this: > > create table test_default ( testint int not null default 1 ); > desc test_default; > > I get: > > +---------+---------+------+-----+----------+-------+ > | Field | Type | Null | Key | Default | Extra | > +---------+---------+------+-----+----------+-------+ > | testint | int(11) | | | 16777216 | | > +---------+---------+------+-----+----------+-------+ > 1 row in set (0.00 sec) > > Why does my default not go in as '1'. I've tried it with and > without quotes. This is vexing. Is there something obvious that > I'm just not doing correctly? > > * Philip Molter > * Texas.net Internet > * http://www.texas.net/ > * [EMAIL PROTECTED] > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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