OK, This is so basic. I have a site in developement that uses passwords. I was using the mySQL password() until I saw on mySQL's manual that you should not. So, I will use MD5 in PHP before the INSERT. I will then use MD% after I do the SELECT for comparison.
Here is the question:
What should the data type be in mySQL?
Someone else setup the database to have the password be varchar(8). This was stripping out the first 8 characters and puting them in the database. Then my full 32 character compare would always fail.
Should I use TEXT, or CHAR(32), or VARCHAR or VARCHAR(32), or TINYTEXT or what?
I want to be proper on watching storing excess data so I figure...ask the experts.
razz