Schroedingerscat
New member
- Joined
- Nov 21, 2011
- Messages
- 1
- Programming Experience
- 5-10
Not sure if this is the correct place to post this so apologies if not. (I've already posted on the SQLite forums but no reply so far)
I'm using SQLite and have some french words stored in one of the tables eg:
When I query the database (into a datatable) and retrieve the string value from the field it shows this:
The value in the field appears to be stored correctly when I view it using SQLiteAdmin so I'm wondering if it's anything to do with the datatable (not sure what though!)
The SQLite DB is in UTF8 and I've tried converting from and to all the different options using System.Text.Encoding but no joy.
I've even tried changing my fonts in VS (2008) just in case it's coming out OK but not showing properly but still no good.
I'm well and truly stuck so any help would be greatly appreciated.
Thanks
I'm using SQLite and have some french words stored in one of the tables eg:
When I query the database (into a datatable) and retrieve the string value from the field it shows this:
The value in the field appears to be stored correctly when I view it using SQLiteAdmin so I'm wondering if it's anything to do with the datatable (not sure what though!)
The SQLite DB is in UTF8 and I've tried converting from and to all the different options using System.Text.Encoding but no joy.
I've even tried changing my fonts in VS (2008) just in case it's coming out OK but not showing properly but still no good.
I'm well and truly stuck so any help would be greatly appreciated.
Thanks
