On 20 Jun 2011, at 9:23am, Jean-Denis Muys wrote: > Select * is not very informative, though we can try to guess. Please select > only the mentioned columns.
Check to see they don't have any unexpected 'invisible' characters in, by doing something like SELECT FullName,LENGTH(FullName) FROM MEMBERS where db_id =1127; and see if the lengths are what you expect. Also check to see that the database doesn't have some lower-level corruption using "PRAGMA integrity_check" http://www.sqlite.org/pragma.html#pragma_integrity_check Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
