dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Dolt table importing csv using UTF-8 with BOM encoding prepends BOM (U+FEFF) to first column's name

Open druvv opened this issue 2 years ago • 0 comments

Found the error while importing a UTF-8 with BOM encoding CSV file using: dolt table import -c

I selected the first column of the file and received an error:

$ dolt sql -q "SELECT col1 from bom_b;"
error on line 1 for query SELECT col1 from bom_b: column "col1" could not be found in any table in scope
column "col1" could not be found in any table in scope

Splunk reveals that the column name is \ufeffcol1

You can download the file here: https://drive.google.com/file/d/1uGGIsRZQg6g_rrG8ke9QYjQ0lPQPQ0Iy/view?usp=sharing

druvv avatar Jul 11 '22 00:07 druvv