> > Still, the RFC does not > > address how to handle rows like this: > > > > 1234,abc"123",abc > > 1235,""123,abc > > Both violate the format as defined. Generate an error message or > interpret them any way that suits you. > > > What are you supposed to do with those? It is not clear. Also, are > > you > > supposed to strip the quotes upon consuming the field? Are you > > supposed > > to un-escape escaped quotes? > > > > "1234" -> 1234 or "1234" ? > > 1234 > > > "15""" -> 15" or 15"" or "15""" or "15"" ? > > 15" > > Simon.
I can appreciate common sense answers, but the RFC doesn't specify those answers. The RFC seems to only address the formatting of the CSV file, not the consumption of it. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
