.net - Encoding problem using SQLite and WinForms 2.0 C# -

I am developing the WinForms app using .NET 2.0 and try to use SQLite as a DB solution I am doing My main problem is that I am having trouble viewing data from DB in WinForm when the data is in a non-English language (Greek in my case).

For the purposes of the DB administration, I have no problem with all the data returned in Greek but when I load the data in my form in the grid view, then I will be able to use them for the dangerous "missing character" class The symbols are found.

I use the solution to communicate with DB.

Am I missing something? I saw to set the default match in the database, but nothing came, because SQLite does not support collation values ​​such as SQL Server (for example COLLATE Greek_CI_AS)

thanks

PS I am using SQLite 3 and System.Data.SQLite.dll 1.0.60. The connection string for the test is: data source = test.db; UseUTF8Encoding = True;

Are you retrieving a string from the database, or a byte array? Internally, SQLite uses UTF-8 or UTF-16 strings (depending on which method to insert the string based on the database), when you use a string value of sqlite3_column_text What does he do then?

On the other hand, if you ask for a blob, it will only return the underlying bytes, which can not match the character expecting your application's encoding.

I'm not sure how the ADO provider maps them underlying operations, but I think if your text is not being sent as Unicode, or this app is otherwise treating it then It can be that where the problem is.

Edit: I think about it, to open your database, to see if there is a difference or not.