how to store html string in sqlite using objective c

Question

I want to store an html description tag into a sqlite database. Basically I convert the tag to a string but when I try to insert it into the database i get a near"0": syntax error. does anyone know of a way I can store the string?

How are you attempting to insert the string? Possible duplicate of: stackoverflow.com/questions/12094120/… (which doesn't have a selected answer, but should help you) — powerj1984
– powerj1984, Commented Dec 11, 2013 at 21:56

bluebamboo · Accepted Answer · 2013-12-12 00:51:16Z

0

I would recommend to use FMDatabase (https://github.com/ccgus/fmdb) as a SQLite wrapper for iOS/Cocoa. FMDatabase is a very popular framework, used in endless projects and well maintained. I heavily use it for more than 4 years.

Code sample:

FMDatabase *db; // Your DB object
[db executeUpdate:@"INSERT INTO table (key,value) VALUES (?, ?)", yourKey, longHtmlString, nil];

answered Dec 12, 2013 at 0:51

bluebamboo

1,29210 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to store html string in sqlite using objective c

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related