Hello !
I'm a new user of Projector and I want to use Excel with myODBC to do some report.
But, i've a problem with accent due to utf8 (i think).
In mysql "é" is register like "é". So when i select a raw with an accent, i've "é" instead of "é" in Excel.
Did someone have a solution ?
Set names or set characters don't work.
I make a precision, display of characters in Projector is correct.
I use mysql 5 an myodbc 3.5 or 5.1.9.
Thanks for your help and sorry for my English.
For your information, i'm not the mysql server administator and i can't change character_set. And the definition of character_set_server is latin1.
I don't know myODBC but it should be possible to parameter it to tell it your database uses UTF-8 chars.
Thanks babynus but i don't find the solution on web.
If someone have a solution...