Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Excel and Accent
 
Notifications
Clear all

Excel and Accent

4 Posts
2 Users
0 Reactions
4,973 Views
(@ericzen)
Posts: 24
Active Member
Topic starter
 
[#259]

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.


 
Posted : 27 Nov 2011 16H06
(@ericzen)
Posts: 24
Active Member
Topic starter
 

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.


 
Posted : 27 Nov 2011 18H31
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

I don't know myODBC but it should be possible to parameter it to tell it your database uses UTF-8 chars.


 
Posted : 27 Nov 2011 20H17
(@ericzen)
Posts: 24
Active Member
Topic starter
 

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

If someone have a solution...


 
Posted : 29 Nov 2011 11H01
Share:

Scroll to Top