socrata / datasync

Desktop / Console application for updating Socrata datasets automatically.
http://socrata.github.io/datasync/
MIT License
79 stars 33 forks source link

Fix parsing CSVs from Socrata #202

Closed rjmac closed 3 years ago

rjmac commented 3 years ago

Our CSVs follow the RFC, and therefore do not escape anything with backslash. So tell OpenCSV that the escape character is NUL (which will also never be in our CSVs because you cannot store a NUL in a postgresql string) in order to prevent misunderstandings.