Export Mysql data to CSV file in UTF-8 format

Asked

Viewed 443 times

0

I’m used to the tool Workbench to access data from my Mysql database, but when I try to export the returned data to a file *.CSV I am unable to export the same in the format UTF-8, but is exported to any other file format (XML, JSON, etc) all data is displayed correctly. It is possible to generate a *.CSV file in UTF-8 format when exporting the result of a Query in the Workbench?

For add-on only, the seat configuration is like this:

inserir a descrição da imagem aqui

  • If I am not mistaken by the result of the query it exports according to the collation of the bank, but I am not sure.

  • Check out this link: https://stackoverflow.com/questions/6860086/mysql-workbench-charset

  • @Anthraxisbr, when you say colação do banco means the original format that the collation is saved?

  • @Fox.11 I followed the link instruction you suggested but mine is already with collarion configured for UTF-8

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.