SQLite - How can one insert HTML code?

Discuss
1

Hi all! :smile:

I’ve been trying to insert several lines of HTML code into a SQLite

Screenshot_20210326_183736
Screenshot_20210326_183736576×105 11.1 KB
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

2

Sorry did not understand. is it just the tag?

3

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:

4

Does that mean you solved it?

5

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

6

Convert html code to base64 string is one way