Embedding quotation marks in a sql string field

I have a string value that for example says


insert into t1 (textval) values ("Joe Smith of the NY Times says 'here is my quote and he said "this" to me and I can't say any more.");

If I escape all the interior quote with \’ or \" when it renders in the browser it is showing little boxes or the Firefox FF something square box but does not render the quotation marks. What am I doing wrong?

Thanks

insert into t1 (textval) values 
( 'Joe Smith of the NY Times says "Here is my quote and he said ''this'' to me and I can''t say any more."' );

Thanks, just noticed that I had left that single quote off at the end. I think I follow it. I’ll let you know if I bump into any issues but it seems pretty straight forward. Thanks again as always, big help.

One more question though. If I need to use multiple double quotes inside, say in quoting magazine names, do I just use them in pairs. Do they need to be escaped in that case? Or are they just ignored as any other character since they are inside the controlling single quotes?

huh? example please?