How can I insert special symbols like trademark into SQLite table? I have tried to use PRAGMA encoding = "UTF-16" with no effect :(
+1
A:
Typically if you surround an SQL entry with ''Single quotes, it goes in as a literal.
i.e.
'™'
Michael Eakins
2010-09-23 13:00:24
problem solved. it is necessary to open DB file with sqlite3_open16, then execute command PRAGMA encoding = \"UTF-16\"; (I am not sure, if it is necessary). Now the insert will be done with UTF-16.
martin pilch
2010-09-23 17:43:44
A:
problem solved. it is necessary to open DB file with sqlite3_open16, then execute command PRAGMA encoding = \"UTF-16\"; (I am not sure, if it is necessary). Now the insert will be done with UTF-16. To select from db (to get column value) is necessary to use sqlite3_column_text16 function
martin pilch
2010-09-23 17:45:13