News for hackers. Stuff that matters.
Re:SQLite as an Application File Format (2014) by kijin on Tuesday December 25, 2018 @12:56AM (#18756172)
> I've even seen CSV with values that contain ``","``!

Are you sure it wasn't an injection attempt of some kind?

Re:SQLite as an Application File Format (2014) by mirimir on Tuesday December 25, 2018 @02:57AM (#18756481)
It could have been, I suppose.

But more likely is twisted creativity. It seems that some businesses are still using ancient systems, based on COBOL, AS/400, etc. There's resistance to changing legacy code. So when business changes require additional data fields, fields sometimes get subdivided. So a field that originally contained stuff like |foo| now contains stuff like |"foo","bar,baz"| or whatever. That works, because there's nothing like CSV in the data system. But when someone tries a CSV export, you get garbage.