Question 22160 in Mysql Question posted in
The official MySQL documentation can be found here.

Unhandled exception: 'ascii' codec can't decode byte 0xc2 in position 3797: ordinal not in range(128) – Mysql

I’m trying to import a .csv file to MySQL using the table data import wizard, but I keep getting this error. Could someone explain what this means and how I would go about fixing it.

Tags:

2

Answers


  1. 0

    I found 0xc2 was  symbol.

    but ASCII code can only express a limited characters.

    I can’t give you an exact answer because of the lack of information.

    check your data, filename, directory name.

    if you find something non-ascii character. maybe that cause exception.

    Login or Signup to reply.
  2. 0

    This means that in your CSV file there is a byte 0xc2, or 194 decimal, known as character "Â".

    Allowed range for characters in given column in your table is 0-127, a.k.a. "normal" ASCII characters, so import was aborted.

    Character "Â" most likely is part of some non-English name. You need to filter it out or change settings of your table to accept character set of CSV file.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search