What do I need to escape in an Insert ?

From: Daniele Orlandi <daniele(at)orlandi(dot)com>
To: pgsql-sql(at)hub(dot)org
Subject: What do I need to escape in an Insert ?
Date: 1998-07-30 22:50:35
Message-ID: 35C0F8BB.EB367157@orlandi.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Suppose I'm going to insert the content of a <TEXTAREA> in a table.
Obviously, there will be characters that could potentially confuse the SQL
statement. What (and how) do I need to escape the data to make it acceptable for
an Insert ?

I currently use the PHP's addlashed function, is it enought ?

Thanks for your response !

Bye!

--
Daniele

-------------------------------------------------------------------------------
Why use Windows, since there is a door?
(By fachat(at)galileo(dot)rhein-neckar(dot)de, Andre Fachat)
-------------------------------------------------------------------------------
Se telecom italia aggiungesse uno scatto al giorno ad ogni abbonato, dal
primo Gennaio avrebbe rubato 669.891.000.000 Lire.
-------------------------------------------------------------------------------
Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Delaney 1998-07-31 04:42:46 Re: [SQL] What do I need to escape in an Insert ?
Previous Message G.Elangovan 1998-07-30 14:09:03 Re: [SQL] Problem in Grant and Revoke Query