storing binary data in a "memory" database

[doc hawk]

bob bobbled,

> How should I define a column in sqLite that is going to properly store and retrieve a password hash? Simply using a BLOB type doesn't do it. 

You shouldn’t need a BLOB for a hash.  Either CHAR(), VARCHAR(), or TEXT.

With the first two, you need to specify a long enough length.