Message - From: Chris W. Parker
[EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, October 27, 2006 10:35 PM
Subject: Performance of different length/size datatypes
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd
, October 27, 2006 10:35 PM
Subject: Performance of different length/size datatypes
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd just cut to the chase and ask...
For a db that doesn't get a lot queries is there much
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd just cut to the chase and ask...
For a db that doesn't get a lot queries is there much of a performance
difference between BLOB and VARCHAR(255)?
Thanks,
Chris.
--
MySQL General
Chris, it should be noted that a BLOB is binary data, not character
data like VARCHAR. BLOBs will act differently in terms of
case-sensitivity for example. The TEXT data type might be more what
you're looking for.
See http://dev.mysql.com/doc/refman/5.0/en/blob.html
for some more info on BLOB