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 6185211F6D05 for ; Sat, 1 Apr 2006 11:08:56 -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 71833-02 for ; Sat, 1 Apr 2006 11:08:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web30305.mail.mud.yahoo.com (web30305.mail.mud.yahoo.com [68.142.200.98]) by postgresql.org (Postfix) with SMTP id D79BB11F61D3 for ; Sat, 1 Apr 2006 11:08:52 -0400 (AST) Received: (qmail 82497 invoked by uid 60001); 1 Apr 2006 15:08:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=eYIf0XMck1/VgzwAuCzt9oxQmyg6aP4tD7aAaoYZYki+W2EzgmEmaWuIot3tlGasDQJ5ZUebPVmpUu32xGEw4giD1wB4Beo85tBZDnbHh1DJ9ieuZemr219EHShVJf+L9jIZ2IrhUfSsCKXRtBM6TG0zOg+Zl/X3SLTxxuw6nFU= ; Message-ID: <20060401150852.82495.qmail@web30305.mail.mud.yahoo.com> Received: from [59.93.198.253] by web30305.mail.mud.yahoo.com via HTTP; Sat, 01 Apr 2006 07:08:52 PST Date: Sat, 1 Apr 2006 07:08:52 -0800 (PST) From: Nirmalya Lahiri Reply-To: nirmalyalahiri@yahoo.com Subject: Re: encryption/decryption To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=3.508 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, RCVD_IN_NJABL_PROXY=0.327, RCVD_IN_SORBS_SOCKS=1.823] X-Spam-Score: 3.508 X-Spam-Level: *** X-Archive-Number: 200604/7 X-Sequence-Number: 93449 Hi Akhilesh, Can you send the script please.... I want to see that. --Nirmalya --- AKHILESH GUPTA 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