I plan on storing text, either null or up to 300 char. I understand that BLOB is case sensitive and TEXT is not. Is there any reason, ie speed improvement, in using one over the other? Otherwise I'll just stick with BLOB.
Thanks, Doug
Well TEXT stores cases also. But if you are doing password/username queries then BLOB is what you probably want to use. You should acctually use TEXT with 300 char. The more you specify the amount of text you are going to use the faster the queries are.
