Re: encryption/decryption

Hi Akhilesh,
 Can you send the script please.... I want to see that.

--Nirmalya


--- AKHILESH GUPTA <akhilesh.davim@gmail.com> wrote:

> 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"
>


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com