X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2E85F52807; Tue, 17 May 2005 15:13:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66472-07; Tue, 17 May 2005 18:13:03 +0000 (GMT) Received: from ns2.instrumentalyst.com (blk-222-55-203.eastlink.ca [24.222.55.203]) by svr1.postgresql.org (Postfix) with ESMTP id 907B15282F; Tue, 17 May 2005 15:13:02 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ns2.instrumentalyst.com (Postfix) with ESMTP id 031E33C1; Tue, 17 May 2005 15:15:21 -0300 (ADT) Received: from ns2.instrumentalyst.com ([127.0.0.1]) by localhost (ns2.instrumentalyst.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 36802-05; Tue, 17 May 2005 15:15:18 -0300 (ADT) Received: from [192.168.2.2] (pcp842727pcs.beridg01.fl.comcast.net [68.56.170.170]) by ns2.instrumentalyst.com (Postfix) with ESMTP id B653A3BB; Tue, 17 May 2005 15:15:17 -0300 (ADT) Message-ID: <428A34D9.5000700@productivitymedia.com> Date: Tue, 17 May 2005 14:15:53 -0400 From: Postgres Admin User-Agent: Mozilla Thunderbird 1.0+ (Macintosh/20050516) MIME-Version: 1.0 To: pgsql-php@postgresql.org Cc: Sql-Postgre Subject: ERROR: unterminated quoted string... help References: <20050517170636.GC12405@phlogiston.dyndns.org> <428A2E81.2060501@pobox.com> In-Reply-To: <428A2E81.2060501@pobox.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: amavisd-new at instrumentalyst.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.093 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/29 X-Sequence-Number: 3143 Hi I'm trying to insert encrypted data into the database and I'm noticing error dealing with quotes. Below is the error print out... suggestions and/or at least point me in the direction to find a solution, Thanks, J INSERT INTO sample.users (user_name, first_name) VALUES ('jokers', '=iF!6(֟㍾̑'-IwiDiJ %') Warning: pg_query() [function.pg-query]: Query failed: ERROR: unterminated quoted string at or near "'=i" at character 68 in /usr/local/apache2/htdocs/php/5/Theirry_DB.php on line 162