On 23 Nov 2017, at 12:40am, Ivan De La Cruz <idelac...@outcomehealth.org.au> wrote:
> SQLiteDataAdapater is dropping characters after a space in the field when > filling a datatable (c# winforms). > > I.e. > 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users