0

I have a problem as this question: Want to add Superscript data to Sqlite database

Can you give me an example about INSERT statement. I don't know more about <sub> and <sup>, and unicode characters.

Thanks you!

Community
  • 1
  • 1
user2678221
  • 15
  • 1
  • 8
  • http://www.sqlite.org/lang_insert.html – Bala Aug 22 '13 at 07:17
  • 1
    The question that you referenced has an accepted answer, so show us what you tried! Also `` and `` is HTML markup and unrelated to Unicode, therefore it is unclear what you actually want. - Apart from that, this looks more or less like a repetition of your previous questions http://stackoverflow.com/questions/18332856/how-to-add-subscript-and-superscript-in-sqlite-ios-programming and http://stackoverflow.com/questions/18326359/how-to-write-subscript-in-xcode-programming. – Martin R Aug 22 '13 at 07:21
  • try inserting the unicodes(in character map). – Agent Chocks. Aug 22 '13 at 07:27
  • Can you give me an example about Insert statement the unicodes – user2678221 Aug 22 '13 at 07:34

1 Answers1

0

try this one

NSString *num = @"20\u02b0";
     NSString *insertSQL = [NSString stringWithFormat: @"INSERT INTO table_name (feild1,feild2) VALUES ('%@',' %@');",num,string2];
Agent Chocks.
  • 1,312
  • 8
  • 19