1;;2 2;2;2The problem is that ICE importer also supports NULLs defined the default MySQL way:
1;\N;2 2;2;2But not with any other escape character, like this:
1;~N;2 2;2;2In ICE you can define a custom NULL indication by setting the BH_NULL session variable, but for some reason this is not handled in the importer.
There are currently a bug report concerning this here.
I've created a patch to solve this "problem", which means that you can define another escape character like this:
LOAD DATA INFILE '/tmp/outfile.csv' INTO TABLE ibtest FIELDS TERMINATED BY '~';
The patch has to be applied in the root of the ICE source code directory.
The patch is tested in ICE 3.3.1, but should also work in any earlier versions.
escapedBy331.patch (2 KB)