When exporting the result of a query as CSV, empty strings and NULL are treated the same way, and they result in "\N" in the output. The issue can be reproduced in 4.2.2 by executing these the following two queries with the option "Paginate results" and immediately afterwards choosing "download" and then selecting CSV as the format.
Both examples send a CSV file with the contents:
The problem is in dataexport.php in all lines that contain this loose comparison:
$v == null
Please use the strict comparison operator to fix it:
$v === null
Log in to post a comment.