if type is null, should be explicit \N in text file