X-Original-To: pgsql-sql@postgresql.org Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 3C4724758E6 for ; Wed, 12 Mar 2003 03:14:21 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Wed Mar 12 09:14:21 2003 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id JAA29258; Wed, 12 Mar 2003 09:14:20 +0100 (MET) Message-ID: <3E6EEC5B.E979BF20@rodos.fzk.de> Date: Wed, 12 Mar 2003 09:14:20 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: vernonw@gatewaytech.com Subject: Re: Special characters in SQL queries Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/280 X-Sequence-Number: 12320 > > I don't program in C at all, but Java. Although I can make a way to call the C library function > from Java, it isn't suitable solution, I believe. > I only desire to find out all the type of characters at the present time so that I can strip out any > potential problem sources in text. Who know what characters a user will enter. > As Victor Yegorov mentioned Take a look at the source code of PQescapeString() in the source distribution of postgres. I hope, you'll find all the chars you're interested in. or refer to Binary Strings within the Data Types chapter of the doc. This shows how to deal with "non-printables" and "printables". Regards, Christoph