One of the tables in my sqlite database file has text containing accented characters(Spanish words). When I do a select query on the sqlite command line and redirect the output to a text file, I am able to see all the accented characters intact. But if I do the same select query programatically using the provider, the accents are gone. Its just plain ascii. I did enable the UTF8Encoding=true in the connection string. Am I missing something? Should I specify the encoding anywhere else - I am using a sqliteDataAdapter and a Dataset to retrieve the results of the query.
Thanks in advance.