i think it's just a length limiter in serversite (mysql server) string longer than this limit will be cut off allowing you to be lazy to cut it off in clientsite (mysql client)
and also a way to indicate the string length, don't have to write a txt file for document >From: "toby -" >To: [EMAIL PROTECTED], [EMAIL PROTECTED] >Subject: Re: question about varchars >Date: Sat, 27 Jul 2002 05:20:01 +0000 > > > > >desmond > >one of my teachers at college once told me to give as less a digit >as possible >that is give it jst a BIT more den i need coz it takes up space >..... > >:S ... > >will someone correct me if im rong here ..... pleez > > >toby .... > > > > >>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? >> >>Thanks >> >>Desmond >> >> >> >> >> >>_________________________________________________________________ >>Send and receive Hotmail on your mobile device: >>http://mobile.msn.com >> >> >>--------------------------------------------------------------------- >>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 >>To unsubscribe, e-mail >> >>Trouble unsubscribing? Try: >>http://lists.mysql.com/php/unsubscribe.php > > > > >_________________________________________________________________ >Chat with friends online, try MSN Messenger: >http://messenger.msn.com > > >--------------------------------------------------------------------- >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 >To unsubscribe, e-mail > >Trouble unsubscribing? Try: >http://lists.mysql.com/php/unsubscribe.php _________________________________________________________________ 与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.microsoft.com/cn --------------------------------------------------------------------- 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