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 and TEXT. Hard to say what difference in performance would be like. If database isn't used much, does it matter much? Dan On 10/27/06, Chris W. Parker <[EMAIL PROTECTED]> wrote:
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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
