encryption/decryption

Поиск
Список
Период
Сортировка
От AKHILESH GUPTA
Тема encryption/decryption
Дата
Msg-id ad39daf90604010255geda323dx9ed2141b9491a574@mail.gmail.com
обсуждение исходный текст
Ответы Re: encryption/decryption  ("chris smith" <dmagick@gmail.com>)
Re: encryption/decryption  (Nirmalya Lahiri <nirmalyalahiri@yahoo.com>)
Список pgsql-general
hi all,
just to ask u all one thing regarding encryption/decryption.

i am migrating my database from mysql to pgSQL using a php script.
in mysql there is a table 'users' where a field 'password' is there of type varchar(30),
and is encrypted using AES algorithm, and when i check all the records in mysql it looks like:-

mysql> select * from USERS;
+----+----------+------------------+-------------------+------------+-------+
| id | name     | password         | password_modified | created_on | admin |
+----+----------+------------------+-------------------+------------+-------+
|  1 | Admin    | \uffff\uffff\u6fde\uffff\uffff
                        \uffff/|\uffff9A | Y                 | 2005-08-10 | Y     |
|  2 | sangeeta | \uffff\uffffX\uffff\uffff\u0215\u0635\uffffkg\uffffg\uffff | Y                 | 2005-08-13 | Y     |
|  3 | check1   | \uffff\uffff\uffff\uffff\uffff\uffffb\uffff\uffff\u0496@\u0274\uffff4 | Y                 | 2005-08-10 | Y     |
|  4 | check2   |                  | Y                 | 2005-08-10 | N     |
|  5 | check3   | V[6\uffff\uffff\uffffw\uffff\uffff\uffff\uffff.C'\uffff | Y                 | 2005-08-10 | N     |
| 16 | user     | 5\uffff\uffff\uffff\uffff<\uffff.\uffff\uffff\uffff\uffff^k | Y                 | 2005-08-10 | N     |
|  6 | admin    | \uffff77\uffff\uffff\uffffs\uffff\uffff3h\uffffM\uffff%\uffff | Y                 | 2005-08-10 | Y     |
| 17 | anita    | \uffff\uffff\uffff\uffff\uffff\uffffH\uffff"\uffffhe)U\uffff | Y                 | 2005-09-27 | Y     |
|  1 | Akhilesh | cheeks           | y                 | 2006-04-01 | y     |
+----+----------+------------------+-------------------+------------+-------+
9 rows in set (0.00 sec)

(all these "ufff\ufff\ufff<\ufff\U\ufff" the password field is seems as special characters like triangles and rectangles, u can say like chinese characters)

now, when i am running my script, then only one record, where name='check2' is copied (because no password is there in this case), but not any other record is displayed.........

plz help me in this case and do tell what should i do to copy all the records.......
(any suggestion either at the php/mysql/postgresql level)
do help me..............plzzzzzzzzz..............!
--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
          (+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

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

Предыдущее
От: "Thomas F. O'Connell"
Дата:
Сообщение: pgpool ABORT + no transaction warning
Следующее
От: "chris smith"
Дата:
Сообщение: Re: encryption/decryption