At 15:23 +0100 3/26/02, Tino Didriksen wrote: >Question about the CHAR to VARCHAR conversion of: >http://www.mysql.com/doc/S/i/Silent_column_changes.html > >Now, I can see the logic in changing most CHAR to VARCHAR if they are long >and variable sized. >I have a column that is VARCHAR(32). I use it to store MD5 hash values. MD5 >hashes are always 32 byte. >In other words, that's 1 byte wasted because it's VARCHAR. > >With 2500 entries and more on the way, that's at least 2500 byte wasted. > >Is there no way to enforce a column type around the silent changes?
No. It makes no sense to do so. >-- Tino Didriksen >http://projectjj.dk/ --------------------------------------------------------------------- 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
