How can i import data from excel csv into mysql

[baig123]

i have lots of data in my excel csv file and having special strings in many rows

i am trying to load but it is accepting few rows and displaying errors for others string type characters like

20727 row(s) affected, 17 warning(s): 1366 Incorrect string value: '\xBF CHAR...' for column 'Original_Description' at row 26 1366 Incorrect string value: '\xB0 DH78...' for column 'Original_Description' at row 1021 1366 Incorrect string value: '\xB0 B-B5...' for column 'Original_Description' at row 1946 1366 Incorrect string value: '\xBF; FLA...' for column 'Original_Description' at row 6373 1366 Incorrect string value: '\xBF; FIT...' for column 'Original_Description' at row 6398 1366 Incorrect string value: '\xB0 CH78...' for column 'Original_Description' at row 7533 1366 Incorrect string value: '\xBF\xBF; IM...' for column


i am trying this query but it is not importing showing errors as shown above

Please Login or Register  to view this content.

[TMS]

Can I suggest that you post a sample of the csv file.

Regards, TMS