What is the correct datatype for storing hashed passwords in mysql?

Question

Hello,

I am writing an application in ColdFusion where storing passwords is necessary. I plan to hash the passwords on the server (using the SHA512 Hash function in ColdFusion) before inserting them into a password column in my database. I would like to know what datatype to use for the password column.

Many thanks!

Answer 1

Depends if your encrypted password may be binary or not : if yes, use blob or varbinary, otherwize char, varchar or text will do it. reference : mysql