X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 3FB2E11F6B87 for ; Sat, 1 Apr 2006 06:55:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28142-10 for ; Sat, 1 Apr 2006 06:55:57 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from pproxy.gmail.com (pproxy.gmail.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 1535911F6B69 for ; Sat, 1 Apr 2006 06:55:55 -0400 (AST) Received: by pproxy.gmail.com with SMTP id s49so1034pyc for ; Sat, 01 Apr 2006 02:55:55 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=ho/ABqWQoBafySpqOUssiqRymXQkzK7v1FvkW1JzHCfrUL4A7CamnuLwMJVzGOzKQcgpX75C9KgGzIGdrVRuHx6z5mfoCk9E4oULOHB59ym65myyyPMapMYN7cCHiQ/G2ffV0CyGvfaOs7Yfvg5wHCzpJHjQ0TId64bglTi+ubU= Received: by 10.65.200.15 with SMTP id c15mr14084qbq; Sat, 01 Apr 2006 02:55:55 -0800 (PST) Received: by 10.65.98.18 with HTTP; Sat, 1 Apr 2006 02:55:55 -0800 (PST) Message-ID: Date: Sat, 1 Apr 2006 16:25:55 +0530 From: "AKHILESH GUPTA" To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: encryption/decryption MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_27092_6837856.1143888955824" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.388 required=5 tests=[AWL=0.387, HTML_MESSAGE=0.001] X-Spam-Score: 0.388 X-Spam-Level: X-Archive-Number: 200604/3 X-Sequence-Number: 93445 ------=_Part_27092_6837856.1143888955824 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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\ufff= f | 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=3D'check= 2' 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" ------=_Part_27092_6837856.1143888955824 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 m= ysql it looks like:-

mysql> select * from USERS;
+----+----------+------------------+-------------------+------------+------= -+
| id | name     | password         | password_modified | created_on | admin |
+----+----------+------------------+-------------------+------------+------= -+
|  1 | Admin    | \uffff\uffff\u6fde\uffff\uffff
            &nb= sp;           \uffff/|\uffff9A | Y            &n= bsp;    | 2005-08-10 | Y     |
|  2 | sangeeta | \uffff\uffffX\uffff\uffff\u0215\u0635\uffffkg\uffffg\uffff | Y            &n= bsp;    | 2005-08-13 | Y     |
|  3 | check1   | \uffff\uffff\uffff\uffff\uffff\uffffb\uffff\uffff\u0496@\u0274\uffff4 | Y            &n= bsp;    | 2005-08-10 | Y     |
|  4 | check2   |            &n= bsp;     | Y            &n= bsp;    | 2005-08-10 | N     |
|  5 | check3   | V[6\uffff\uffff\uffffw\uffff\uffff\uffff\uffff.C'\uffff | Y            &n= bsp;    | 2005-08-10 | N     |
| 16 | user     | 5\uffff\uffff\uffff\uffff<\uffff.\uffff\uffff\uffff\uffff^k | Y            &n= bsp;    | 2005-08-10 | N     |
|  6 | admin    | \uffff77\uffff\uffff\uffffs\uffff\uffff3h\uffffM\uffff%\uffff | Y            &n= bsp;    | 2005-08-10 | Y     |
| 17 | anita    | \uffff\uffff\uffff\uffff\uffff\uffffH\uffff"\uffffhe)U\uffff | Y            &n= bsp;    | 2005-09-27 | Y     |
|  1 | Akhilesh | cheeks           | y            &n= bsp;    | 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=3D'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 recor= ds.......
(any suggestion either at the php/mysql/postgresql level)
do help me..............plzzzzzzzzz..............!
--
Thanks & R= egards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)GSM:-(+919891606064)
        &n= bsp; (+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING = LOW IS A CRIME" ------=_Part_27092_6837856.1143888955824--