Pavel Machala wrote: > I am struggling with this very random and rare issue where last character > of string - always “]” in multiple columns is replaced with one or more > unexpected characters.
SQLite does not change the contents of strings, and treats them exactly like blobs (unless you excplicitly call string modification functions). > We create the db within android app. We also use ContentValues for safe > inserts of rows into Table. The Android framework automatically takes care of all encoding conversions. > - Why is the issue in first case so consistent for fields created with > StringBuilder? Do you get the wrong result from StringBuilder? Do you even know when exactly this happens? > - Is there anything we could do to avoid it or at least do some further > debugging? Find out when exactly this happens. Check that the entry in ContentValues is correct just before the insert() call. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
