r/programming • • Nov 16 '14

PostgreSQL vs. MS SQL Server - A comparison of two relational databases from the point of view of a data analyst

http://www.pg-versus-ms.com/
171 Upvotes

321 comments sorted by

View all comments

Show parent comments

10

u/scragar Nov 16 '14

Obviously you've never exported Unicode CSV files in 2005 or earlier.

There was a pretty serious bug that caused exporting any Unicode in Unicode mode to cause corruption of the CSV file, while ASCII mode would export fine(but without the byte order marker making significant problems if you wanted to use it and didn't know how to fix the issue).

It was fixed in 2008, but I can understand why someone who didn't know it was fixed would complain about it, the bug was around for a long time and should not have been an issue in the first place.

1

u/Cuddlefluff_Grim Nov 17 '14

I chronically avoid CSV and I had no idea they had actually fixed it. Now I know, thank you :P