Generating google chart from mysql column with accent

Question

I'm generating google charts from different months in a year. Every month seems to work fine except for months(février) with accent. It has an error message saying Table has no column. In the mysql table I have a column like this (1-févr), (2-févr) ... Is the accent the cause of the error? If so, how could I fix it? Thanks!

EDIT: I realised the problem is with JSON_encode, and all I needed to do is to use the utf8_encode function to my data before I convert them to JSON.

Answer 1

When selecting the column form the database use backticks surrounding the column name, so the query before would look like so:

SELECT 1-févr, 2-févr FROM table

This would need to be changed to:

SELECT `1-févr`, `2-févr` FROM table

Please be careful, these are backticks and not quotes ie it is ` and not ' or ".

This ensures the string is evaluated as a whole and not broken due to characters such as hyphens etc.