On Tuesday 26 February 2002 4:00 pm, Scott Broderick wrote: > Hello group! I am a newbe to this listing. > > What I am attempting to do is pass a number like "0123456" to a field in > the mysql database which is setup as int(11) but for some reason, the zero > is not > written into the database but instead all that is written into that field > is "123456" > What am I doing wrong? Can someone help me please? Thanks
What is wrong is your expectations. If you want to store the leading 0, you are NOT wanting to store an int. Instead, you are wanting to store a string (aka char or varchar). --------------------------------------------------------------------- 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
