I have an SQLite database with foreign words. I am trying to run sql select statements entered into a textarea in XOJO. I can successfully run searches on numeric (integer) fields such as “select * from words where id=751”. Searches trying to find specific words such as “select * from words where word=‘oui’” fail.
I am able to successfully run such searches in another software: SQLite Manager. When I copy and paste searches from SQLite Manage into my XOJO textarea the searches work. However, if I edit even one character after pasting the sql into my XOJO textarea the search fails. I’m flummoxed as to why it works sometimes (when copy and pasted) but not others.
I suspect there may be a text encoding problem, but I haven’t been able to figure it out. The database was created by using XOJO to take the words from a web page and store them in SQLite. I believe that the web page was in UTF-8, although I am not sure. When I look at the ascii codes for some of the letters (vowels with diacritical marks), they are in the 200 range which corresponds to UTF-8 Latin Supplement as show at https://www.w3schools.com/charsets/ref_utf_latin1_supplement.asp). Any suggestions?