News for hackers. Stuff that matters.
Re:PostgreSQL 10 Released by tatersolid on Sunday October 08, 2017 @05:22PM (#15430060)
There is no such thing as “Valid CSV”. It’s an ambiguous format, with dozens of variants.

SQL server supports CSV with exactly the same senantics as Excel. Which is what people expect 99.9% of the time, because most CSV data goes to or from Excel in the real world.

If you’re DB-to-DB imports and exports, use a sane file format with a sane delimiter such as the Unicode INFORMATION SEPARATOR and RECORD SEPARATOR characters which were inherited from ASCII.

There are no comments on this comment yet.