: Re: Enforcing Column Types
Tino Didriksen queried:
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.
2500
On 26 Mar 2002, at 15:23, Tino Didriksen wrote:
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.
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
* Paul DuBois
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
At 16:55 +0100 3/26/02, Roger Baklund wrote:
* Paul DuBois
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
Tino Didriksen queried:
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.
2500 bytes out of 82,500? Three