Crypto, strings, and SQLite

General
2

  1. no - PBKDF2 returns a memory block = “bucket o’ bytes”

  2. no - not unless you encode it

  3. without knowing how you retrieve it that one is hard to say but if you insert it as “plain bucket o’ bytes” and retrieve it without defining and encoding then its a column that is a bucket of bytes and it should compare fine

Be aware that depending on how you insert it (hand crated sql vs prepared statement) you may need to base 64 encode it