How to store encrypted data into database

Поиск
Список
Период
Сортировка
От Sudheesh Krishnankutty
Тема How to store encrypted data into database
Дата
Msg-id 3DA3BED9.B5C69983@softjin.com
обсуждение исходный текст
Список pgsql-novice
Hi all,

I am creating a table that contains userid and encrypted password.
I am using SHA-1 algorithm for encrypting the plain text password.
I stored the encrypted password into tht postgres database as varchar.
While retrieving I found that all the characters are changed.

How should I store the encrypted password.  My understanding is that
while storing as varchar the character encoding changes the encrypted
text.
I am I right?

So how to store the encrypted text.

regards
sudheesh

Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What causes a table's oid to change?
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: What causes a table's oid to change?