#22 special value representing NULL

[Mario Frasca]

accept a property that specifies a string that will be interpreted as the SQL NULL value. all getters on that field will then return Null.

the property could be called nullString. the default value could be "NULL" and I would prefer to have it case sensitive.

[Simon Chenery]

Is this necessary?

You can use the SQL NULLIF function to convert unwanted column values to NULL and it is usable with other SQL expressions:

-- Convert 'NULL' to NULL
SELECT AUTHOR, NULLIF(COMMENT, 'NULL') FROM POSTS

-- Convert 'NULL' in any case to NULL
SELECT NULLIF(UPPER(COMMENT), 'NULL') FROM POSTS

[Simon Chenery]

Also requested in csvjdbc-develop topic Feature request: Adding more line skipping options.

[Simon Chenery]

Also requested in csvjdbc Help Forum topic Is there a way to handle missing values.