In general type `:text` was used to store encrypted attributes in the
database.

This change recommends to use `:binary`. This makes use of the `bytea`
type in PostgreSQL and makes storage more efficient.

Related to https://gitlab.com/gitlab-org/gitlab/-/issues/227779