[ppa-help] [ phppgadmin-Bugs-2716779 ] Exporting empty strings as CSV gives \N

[SourceForge.net <no...@so...>]

Bugs item #2716779, was opened at 2009-03-27 12:29
Message generated for change (Settings changed) made by ioguix
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=2716779&group_id=37132

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Import/Export
>Group: GIT
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Jan Normann Nielsen (normann1974)
>Assigned to: Guillaume `ioguix` de Rorthais (ioguix)
Summary: Exporting empty strings as CSV gives \N

Initial Comment:
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.

Query 1:

SELECT '';

Query 2:

SELECT NULL;

Both examples send a CSV file with the contents:

"?column?"
"\N"

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

----------------------------------------------------------------------

Comment By: Guillaume `ioguix` de Rorthais (ioguix)
Date: 2010-08-27 00:01

Message:
Hey,

I just fixed the bug in our current dev tree.

You can download a snapshot of our current dev tree here : 

  http://github.com/xzilla/phppgadmin

Thanks for the report !

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=2716779&group_id=37132