This piece of code will replace the following tested values with 'NULL': '0', ''. which is incorrect. A NOT NULL column could be set to an empty string or a VARCHAR column can be set to '0' for example. IMHO the only valid mapping for 'NULL' is the null type.