Not sure what's going on here. I created the following query to produce quantity results by month:
SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear,
COUNT(*) AS total
WHERE status = 'Online' AND Year(published) = 2013
GROUP BY CONCAT( MONTHNAME(published) , ' ' , YEAR(published))
I expected to see the following:
March 2013 103
April 2013 87
May 2013 23
June 2013 99
But got this:
How can I get rid of the funny characters and have English instead?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!