Helpful Information
 
 
Category: MySQL
Blob/text

There is.. TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB, and TEXT versions of each. How big is each one, and how do I know which to use (I mean, text or blob?)?

pretty much whichever you like the sound if ! from the manual...



The four TEXT types TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT correspond to the four BLOB types and have the same maximum lengths and storage requirements. The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive fashion for BLOB values and case-insensitive fashion for TEXT values. In other words, a TEXT is a case-insensitive BLOB.

.......... so make sure all your password fields are BLOBS rather than TEXT - I made that mistake!

patrick










privacy (GDPR)