How to add html page code to table?

Question

SQL

I'm trying to do this (the html example is random, for example):

insert into MyTable values ('page1', '<div bgcolor='f2f2f2' style='margin: 0;padding: 0;min-width: 100%!important;' yahoo=''>')

But because of the quotes, everything breaks. How can the problem be solved?

Answer 1

If you do not need a search in the html text - then as an option - encode in base64 when saving to the database.
Then you can store whatever you like - even binary data ...

Answer 2

Use double quotes in html:
Or escape single quotes:
...bgcolor=\'...\'