X-Original-To: pgsql-sql@postgresql.org Received: from shakti.rupa.com (adsl-66-125-43-50.dsl.lsan03.pacbell.net [66.125.43.50]) by postgresql.org (Postfix) with ESMTP id C166E47592C for ; Wed, 12 Mar 2003 00:50:31 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by localhost.rupa.com (Postfix) with ESMTP id 83AD13EA34 for ; Tue, 11 Mar 2003 21:50:37 -0800 (PST) Received: from shakti.rupa.com ([127.0.0.1]) by localhost (shakti [127.0.0.1:10024]) (amavisd-new) with ESMTP id 00553-09 for ; Tue, 11 Mar 2003 21:50:36 -0800 (PST) Received: by shakti.rupa.com (Postfix, from userid 9) id 5F43B3EA0B; Tue, 11 Mar 2003 21:50:36 -0800 (PST) Received: from 192.168.1.20 by 192.168.1.20 with nntp; 11 Mar 2003 21:50:36 PST To: pgsql-sql@postgresql.org Subject: Re: Special characters in SQL queries From: Rupa Schomaker Mail-Copies-To: never Date: Tue, 11 Mar 2003 21:50:36 -0800 Message-ID: User-Agent: Gnus/5.090016 (Oort Gnus v0.16) Emacs/21.2 References: <3E6E0191.B8F06EBB@rodos.fzk.de> Cancel-Lock: sha1:0nL9SikL87CHlebaD+Q0oFEr4do= MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii NNTP-Posting-Host: 192.168.1.20 X-Virus-Scanned: by amavisd-new-20021227-p2 (Debian) X-Archive-Number: 200303/293 X-Sequence-Number: 12333 -----BEGIN PGP SIGNED MESSAGE----- Vernon Wu writes: > 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. Why not strictly use bind variables? That way you never have to worry about escaping and you get the added bonus of using prepared statements? - -- - -rupa -----BEGIN PGP SIGNATURE----- Version: 2.6.3ia Charset: noconv Comment: Processed by Mailcrypt 3.5.7, an Emacs/PGP interface iQEVAwUBPm7KqnHDM4ucEopdAQFs+Af/d2DMjOWrLhN5S0TdwJGrelvYMwCvpSd3 QZrdx2fv3tGHx1JjqlZgKRKrn08GWMe+AjN2I89FfjyG0vurOqLSAJA4pGI0guGF 9cqXWQJTXd5yMEencG3Va7VhF8WcEmGX1iC891s7xdssmQW1myKZIKwrLPO3jVla SRFqh4xPycyJk8L6McbWoGwQa5I+xvLKWlS38tr1tQZu4bbg0o4pDnTYVLvdswH/ oM6ZOk4fHwK7/E4071jNYTWe9azmylJfWpqJCELc+9k4afibcdOTLXvWk0Re438d 6wGadJ5tpT65onaSYzpUENTmedY1CPAG+ViL+t8rMgBI/jGoKFXxJg== =t25X -----END PGP SIGNATURE-----