I am using the Firefox plugin of SQLite and this is a large CSV file that I am importing in the wizard. When I try to import, I get that error
CHECK constraint failed: REDCs_refined ] Exception Name: NS_ERROR_STORAGE_CONSTRAINT Exception Message: Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute] Dan Telvock Environment Reporter Investigative Post <http://www.investigativepost.org/> Twitter: @dantelvock 716-831-2626 ext. 3 On Mon, Apr 4, 2016 at 12:21 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 4 Apr 2016, at 5:04pm, Daniel Telvock <dtelvock at investigativepost.org> > wrote: > > > When you have a columns that has lengthy text, is there a way to label it > > so SQLite won't spit it out as an error? > > There is no problem with storing lengthy text in a SQLite field. It makes > no difference how you label the column since everything gets converted to > TEXT anyway. Whatever your problem is it's not related to labelling. > > Please state your platform and development environment. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
