accented characters

Developers
Sowmya
2005-02-21
2013-04-15
  • Sowmya
    Sowmya
    2005-02-21

    Hi,
    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.
    -Sowmya