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? -- 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