'MySQL wont import CSV File with µ Symbol

Im trying to import a csv file that has the symbol µ in of the columns. The destination is just a VARCHAR and the source CSV is UFT-8 Plain text. I get the following error. If i remove the symbol it imports ok but I actually need the symbol stored in the database.

Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal not in range(128)

ANy ideas appreciated

mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions