# Suggestions for mysql column type for password

**URL:** <https://forum.kirupa.com/t/suggestions-for-mysql-column-type-for-password/63570>\
**Category:** programming\
**Created:** [September 8, 2004, 2:53am UTC](https://forum.kirupa.com/t/suggestions-for-mysql-column-type-for-password/63570 "2004-09-08T02:53:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![boristheblade](https://avatars.discourse-cdn.com/v4/letter/b/848f3c/32.png) [@boristheblade](https://forum.kirupa.com/u/boristheblade)\
**Post date:** [September 8, 2004, 2:53am UTC](https://forum.kirupa.com/t/suggestions-for-mysql-column-type-for-password/63570/1 "2004-09-08T02:53:35Z")

</div>

Does anyone have any suggestions on what column type to use to store an md5 encrypted password for a user table and why?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 8, 2004, 3:56am UTC](https://forum.kirupa.com/t/suggestions-for-mysql-column-type-for-password/63570/2 "2004-09-08T03:56:37Z")

</div>

varchar will be sufficient.

md5 will always result in printable ascii characters, which makes varchar perfect.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 8, 2004, 11:27pm UTC](https://forum.kirupa.com/t/suggestions-for-mysql-column-type-for-password/63570/3 "2004-09-08T23:27:16Z")

</div>

Thanks JustJeff,  
cute pug btw.