db2topg icon indicating copy to clipboard operation
db2topg copied to clipboard

empty string inserted as null

Open lianji-li opened this issue 3 years ago • 0 comments

My solution is check quoted when $field eq ''

		if ($field eq '') # fast exit for empty (should mean null)
		{
			if ($colnull[$num] == 1)
			{
                                    my $quoted = $csv->is_qoted($num);   # keep empty string
				$field = $quoted ? '' : '\N';
			}
			# No need to set it at '' if null isn't authorized, it is already
			$outrow.= $field;
			next;
		}

lianji-li avatar Mar 01 '22 08:03 lianji-li