Excel and Accent

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.

Thanks babynus but i don't find the solution on web.

If someone have a solution...