Storing as 'String' with Postgres & ActiveRecord Fails at Null Character

[CKolkey]

Had an issue with the database configuration as recommended. After a little research it seems that the correct way to set up the 'encrypted_*' columns is as binary data, not as a string. Does this sound right? It solved my problem.

create_table :users do |t|
    t.string :name
    t.binary :encrypted_ssn
    t.binary :encrypted_ssn_iv
    t.timestamps
  end