Hello everybody,
I am having a problem using Sqlite with .Net / visual studio and you really need your help.
The problem is this:
I have garbled text in the ID column with the "uniqueidentifier" data type in Sqlite Database while viewing table data using some GUI tools (I try different tools)
This is clearly visible when retrieving data in .net code, but just making me nervous.
More details here:
When I open a table using Sqlite Administrator, it displays garbled text in the ID column.
BUT, when I use visual design, the specified table data adapter or the general SqliteDataAdaptor to retrieve the table, the identifier column shows thin.
This is how I create distorted data.
First, I drag the table into the visual designer of the studio dataset through the server explorer using dll dll dll dll dll cdlite.
Modify the data programmatically, then use the visual data adapter to update it.
My suspension
I suspect that the SqliteDataAdaptor (or .net adapter inside?) Is inserting UNICODE encoding into the database. Thus, when retrieving data through the adapter, it will display perfectly. But GUI tools cannot handle unicode, so does it show garbled text?
Last
I do not know if the data type is "uniqueidentifier" in the Sqlite database. But in the database file I got from other colleges, it shows the type as "uniqueidentifier" and it seems to work.
Thanks to everyone in advance.
Greetings