Re: Storing '&' in the database

From: Peter J. Schoenster <peter_at_schoenster.com>
Date: Fri, 10 Nov 2000 12:58:34 -0700
Message-Id: <10676.121777@fatcity.com>

On 10 Nov 2000, at 10:18, Sridhar Moparthy wrote:

> Do you know how to store data that contain '&' in to a table.

Hi,

I use Perl DBI/DBD and quote when I have to. I have no trouble inserting ampersands.

When I use a brute-force method of inserting data I do this:

set scan off;
DROP TABLE schools;
CREATE TABLE schools (

etc.

That allows me to have ampersands in the data that is getting entered.

I found that here:

Peter

"Reality is that which, when you stop believing in it, doesn't go away".

Received on Fri Nov 10 2000 - 13:58:34 CST