mysql encoding

0

I have the data in the database, in the charset utf-8, and I want to export the listing in .csv, however when I give a select it returns me the data, for example "Property and Property Management ". How do I return the data in the selected accented correctly?

PS. I'm using HeidiSQL.

    
asked by anonymous 07.05.2015 / 18:55

1 answer

0

Try to make your query look like this:

SELECT convert(campo USING latin1) FROM tabela

With more than 2 fields

SELECT convert(campo USING latin1), convert(campo2 USING latin1) FROM tabela

campo - is the information you want to list.

    
07.05.2015 / 19:02