Support for NULL shorthand (\N)

ibm-watson-data-lab / simple-search-service

A faceted search engine and content API.

39 stars 27 forks source link

Support for NULL shorthand (\N) #2

Closed glynnbird closed 9 years ago

glynnbird commented 9 years ago

Raised by @mikebroberg from another repo:

When you write data to file from MySQL, it uses a shorthand for NULL values in the resulting CSV or TSV: \N See https://dev.mysql.com/doc/refman/5.0/en/null-values.html for more.

It would be cool if SEaMS could support this. I guess you wouldn't want to have the option to import as JavaScript's null datatype, but maybe have it in there as a string? Dunno.

glynnbird commented 9 years ago

a value of "\N" is changed to "null"