News for hackers. Stuff that matters.

A comment on Excel and SQL. Parent comment

Re:Excel and SQL by redman25 on Thursday May 23, 2013 @07:08PM (#5760141)
Excel's CSV export has a lot to be desired. From what I've tried, it doesn't export data in Unicode and exports non-standard CSV that many parsers choke on.
[ Parent | on HN ]
Re:Excel and SQL by kyllo on Thursday May 23, 2013 @08:33PM (#5760508)
Excel exports CSV in UTF-16 with byte order mark (BOM). Very annoying if you're sending the data to another application that is expecting UTF-8.
[ Parent | on HN ]