SQLite - How can one insert HTML code?

Hi all! :smile:

I’ve been trying to insert several lines of HTML code into a SQLite Screenshot_20210326_183736 TEXT or BLOB field.

CREATE TABLE IF NOT EXISTS Instructions (‘id’ INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, ‘CRCData’ BLOB);

Putting

HTML

by itself into the INSERT statement works, but trying to put

<HTML>

into the INSERT statement does not work. :unamused:

I have no single quotes in the HTML doc, and I’ve tried to escape the HTML code to no avail.

Any help would be greatly appreciated! :sunglasses:

-Kevin

Sorry did not understand. is it just the tag?

The data in the Airtables base/field is an entire HTML document. I was trying to place the document into SQLite. :no_mouth:

I decided instead to use “File” instead of SQLite for this purpose. Works exactly as I wanted it to work. :laughing:

Does that mean you solved it?

Well, no, actually. :thinking: I still don’t know how to put HTML code into an SQLite DB. While I no longer need to know for my current app, someone else might want more info, so I left it open hoping for a solution for the initial problem. :stuck_out_tongue_winking_eye:

-Kevin

Convert html code to base64 string is one way