So I don't know if this is related to the character issue but I have an sqlite (2) database that I am trying to read.
Unfortuntely, one of the tables uses a string for the ID which can include apostrophes. When I view the database via the sqlodbc drivers, I get the correct value for the field (e.g. "joe's table") but when I do a reader.GetString() using the ADO provider, I get the wrong value (it shows up as "joe4s table" in the debugger). When I then try to use it to do a query, it (obviously) fails.
I have tried changing the encoding but that had no effect (actually setting it to UTF8 totally removes the apostrophe - "joes table") which also fails).
I tried a hack and replaced "4s" with "'s" but that failed also...
Help!?!
-Jon
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So I don't know if this is related to the character issue but I have an sqlite (2) database that I am trying to read.
Unfortuntely, one of the tables uses a string for the ID which can include apostrophes. When I view the database via the sqlodbc drivers, I get the correct value for the field (e.g. "joe's table") but when I do a reader.GetString() using the ADO provider, I get the wrong value (it shows up as "joe4s table" in the debugger). When I then try to use it to do a query, it (obviously) fails.
I have tried changing the encoding but that had no effect (actually setting it to UTF8 totally removes the apostrophe - "joes table") which also fails).
I tried a hack and replaced "4s" with "'s" but that failed also...
Help!?!
-Jon