Export SQL produces '' for a NULL value

[Former user]

Originally reported on Google Code with ID 109

What steps will reproduce the problem?
1. Tab export


What is the expected output? 
file with:
CREATE  TABLE trends( id INTEGER PRIMARY KEY NOT NULL, info BLOB);

----
-- Data dump for trends, a total of 1688 rows
----
BEGIN TRANSACTION;
INSERT INTO trends (id,plek,tyd,name,info) VALUES ('1',NULL);

What do you see instead?
file with:
CREATE  TABLE trends( id INTEGER PRIMARY KEY NOT NULL, info BLOB);

----
-- Data dump for trends, a total of 1688 rows
----
BEGIN TRANSACTION;
INSERT INTO trends (id,plek,tyd,name,info) VALUES ('1','');


What version of the product are you using? On what operating system?
version 1.9.2
----------
To me this is only a minor thing, but you may be interested to know.
I think your product is great!!!
Eke van Batenburg ([e-mail])

Reported by ekevanbatenburg on 2012-06-04 08:32:50

[Christopher Kramer]

``` Thanks for reporting this. You are totally correct that this should not be the case, as NULL is of course something different than ''. We will have a closer look at this and fix it. ```

Reported by `crazy4chrissi` on 2012-06-04 17:31:54 - Status changed: `Accepted`

[Christopher Kramer]

This issue was closed by revision r240.

Reported by crazy4chrissi on 2012-10-22 21:42:12 - Status changed: Fixed

[Christopher Kramer]

I just fixed this with SVN revision #240.
You can get the current file from SVN here:
http://phpliteadmin.googlecode.com/svn/source/1.9.3/phpliteadmin.php

Please let me know if the problem still occurs in this version.

Reported by crazy4chrissi on 2012-10-22 21:44:33

[Former user]

Thank you for your work on this bug.
I am very, very happy with phpliteadmin.
Naturally I will report any problems I might meet.

Thanks again........Eke van Batenburg

Reported by ekevanbatenburg on 2012-10-23 09:21:45

[Christopher Kramer]

Reported by crazy4chrissi on 2013-03-09 17:08:06