Hello! Desmond Lee wrote:
> Hello there > > > Mysql documentation says the following: > > "values are stored using only as many characters as are needed, plus > one byte to record the length. Values are not padded; instead, > trailing spaces are removed when values are stored." > > > So, then would there be anything wrong with making all my varchar's up > to 255. That is defining most of my fields to be varchar(255) even > when i know they may only go 100? There's nothing wrong with it for storage reasons only, but many database developers use lengths to restrict the size of the entries. For example storing the zipcodes from more than one country might need at max 15 characters, so why allowing 255, preventing MySQL to raise an error, if the ZIP is 100 chars long. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH & Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de --------------------------------------------------------------------- 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
