News for hackers. Stuff that matters.

A comment on Q: Run SQL Directly on CSV Files. Parent comment

Re:Q: Run SQL Directly on CSV Files by bane on Thursday November 15, 2018 @08:33AM (#18459074)
No it's fine. Just base64 encode the binary data. It's common and streams, or you can capture and convert the entire field at once if you need to seek around in the binary data.

https://en.wikipedia.org/wiki/Base64

[ Parent | on HN ]
Re:Q: Run SQL Directly on CSV Files by zbentley on Thursday November 15, 2018 @09:50AM (#18459605)
That only works if the thing consuming your CSV can be configured to decode whatever encoding you picked. Uploading CSVs of data to various SQL servers is an example case where that is often not possible.
[ Parent | on HN ]