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';