MySQL question

Karla

Anybody know how to allow BLOBs that contain single quotes into a record? At the moment I have to strip them from the incoming text and I can't see any reliable way of putting them back

Here's the problem:

---

$text = "It's a way of life";

$sth = $dbh->prepare("INSERT INTO table(text) VALUES('$text')");

---

The single quote inside the string is interpolated. I was thinking maybe I could replace them with something else before I put them into the record and then swapping back when I take it out of the record, but what could I use? Would it be safe to use some weird ASCII character for this?

Thanks


Doh! I could just wrap the SQL statement in single quotes couldn't I?


[This message has been edited by Karla (edited 30-01-2000).]

kayos

ok first thing first why are you tring to put a string in a image field. Well here it goes any who. If you want to put single quotes into a string field you would use syntax as follows.
Insert
TableName
(
FieldName
)
Values
(
'It''s a way of life'
)
Note that It's has two single quotes and not a double quote. Well thats how you do a string field in SQL Server so it should work for you. If you need any more help just give us a shout.

Kayos

[This message has been edited by kayos (edited 31-01-2000).]