> SQLiteDataAdapater is dropping characters after a space in the field when filling a datatable (c# winforms).
> Field : 100 ml
> Select returns : 100 ml
> DataTable column after Fill : 100
> If I add ' marks around the text : '100 ml'
Is the column defined as numeric ? If so, then SQLite is doing the right thing. It is parsing the string and retrieving a number from it.
If not, please tell us which versions of which development tools you’re using so other people can reproduce your results.