Mysql encoding

Asked

Viewed 83 times

0

I have the data in the database, in the charset utf-8, and I want to export the listing in . csv, but when I give a select it returns the data so for example "Administraã§ã de Imã³veis e Locaã§Ã". How do I return the data in select accented correctly?

P.S. I’m using Heidisql.

mysql character-encoding utf-8

  • You are using PHP??

1 answer

0

Try to make your appointment 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.

Browser other questions tagged mysql character-encoding utf-8

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