MySQL work bench Database Error: Invalid utf8 character string

Last Reply 8 months ago By dharmendr

Posted 8 months ago

 i am using my sql work bench database.  i am imporing excel data in mysql workbench database.

Note: i also specify the character set with CHARACTER SET when i run the above query shows error as follows Error Code: 1300. Invalid utf8 character string: 'NAVA,1057673,SHYAMALA V,Fema, 2007-10-31 00:00, 1943-06-13 00:00

LOAD DATA LOCAL INFILE 'C:/Users/1900057/Desktop/Sql Query/sndata.csv'
INTO TABLE sample.clinicalsample
CHARACTER SET UTF8
COLUMNS TERMINATED BY '\t' 
LINES TERMINATED BY '\n';