At 16:07 + 2001/11/13, Carl Troein wrote:
>//C - with a runny nose, a cup of tea, and a glass of Laphroaig
...for medicinal purposes, of course. :>
My choice was McClellands, when reduced last week to a sorry-ass blob
of protoplasm by the worst cold I've had in years.
Feeling much better
At 4:07 PM + 11/13/01, Carl Troein wrote:
>Carsten H. Pedersen writes:
>
>> I assume that there is a small speed penalty in using TEXT/BLOB
>> fields, as compared to VARCHARs.
>
>I recall seeing some test where TEXT was actually faster, but
>it might have been in some special situation. On t
Carsten H. Pedersen writes:
> I assume that there is a small speed penalty in using TEXT/BLOB
> fields, as compared to VARCHARs.
I recall seeing some test where TEXT was actually faster, but
it might have been in some special situation. On the whole,
I think that being able to specify a length
> http://www.mysql.com/doc/n/o/node_357.html
>
> explains the different string data types and the storage requirements:
>
> Column Type Storage required
> [...]
> VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255
> [...]
> TINYBLOB, TINYTEXT L+1 bytes, where L < 2^
http://www.mysql.com/doc/n/o/node_357.html
explains the different string data types and the storage requirements:
Column Type Storage required
[...]
VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255
[...]
TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8
[...]
These t