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"