Exporting Excel CSV generates a "\N" value in NULL fields

mpmaggi posted 4 years ago in Import/Export

I'm using HeidiSQL 8.1 and everytime i export data with Excel CSV format, whenever the field is NULL, the excel gets a "\N" in the cell.
This issue did not happened with 8.0.

Tested with last build 4591 and it's the same as described.

ansgar posted 4 years ago
There is a new optional "NULL value" input box in the export dialog, which you may not have noticed. Watch out for it in the lower right of the grid export dialog. \N is just the default value for it.
mpmaggi posted 4 years ago
Oh, sorry then, totally my bad.

Awesome improvement, by the way!

Thanks a lot!!

Please login to leave a reply, or register at first.