Hello,
What you say below is of great interest to me. Currently I have been writing front end code to handle the size issue but I would like to be open to other possibilities. So my question about your answer below is: Just how does the developer obtain the error condition from Mysql when an insert or update sends data that is too long to a field with a restricted size? Thanks -----Original Message----- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 1:59 AM To: Desmond Lee Cc: [EMAIL PROTECTED] Subject: Re: question about varchars 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 --------------------------------------------------------------------- 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
