I must get information from MySQL (reports of cities in Colombia) so I make the following query:
select id, name, slug, latitude, longitude, region_id, province_id, district_id from places;
The query works and gives me all the results
The problem is that all the queries come out with things like: ������
nose
My specific question is: Is it possible to view the query from the console with accents and ñ????
Start the client indicating the default charset
Or, for version with full UTF implementation
Which can even be defined by default in the configuration (
/etc/mysql/my.cnf
on Linux):When you are in the new console session applying any of these changes, check that everything is in UTF8 with
Check what encoding your data and table are in. If they are in latin1, you have to do this setting but using
latin1
.(Answer generated from this )