rporter45
asked on
Problem with special characters in database and exporting
I have a UTF-8 mySQL database that is for some reason is displaying special characters incorrectly in the backend and when I export the data no matter what format while when viewing the data in the front end web application is displays correctly. Ultimately I am looking to export the data in an Excel or CSV file correctly. Can anyone help?
The Windows programs usually use Windows-1252 character set which is roughly Latin-1. What is your "Front end web application" and how are you sending the data to it?
This article is usually recommended. http://www.joelonsoftware.com/articles/Unicode.html
This article is usually recommended. http://www.joelonsoftware.com/articles/Unicode.html
And by the way, changing the 'character set' does Not change the codes in the text, it is just there to tell a program how to interpret them. If the codes get mixed up because different programs did different things, it is next to impossible to straighten them out.
ASKER
The front end application is a custom PHP based app. I am not familiar with more details of the web app.
You are supposed to make sure that all communication and display and processing uses the same character set. I suggest that you click on "Request Attention" above and get some other zones and experts added to your question. Maybe they can add some detail for you.
ASKER
Which zones would you suggest?
PHP and Excel for starters. Is the web application displaying the characters correctly?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. Anyone else have anything to add that could help?
@rporter45: Did you read the article? It shows exactly what happens when you have those collisions. Do you still have any questions about why this is happening? If so, please show us your test case and we will try to help.
Let's see... No response to our questions and request for test data, and a marked-down grade. According to the grading guidelines, you owe us an explanation.
http://support.experts-exchange.com/customer/portal/articles/481419
http://support.experts-exchange.com/customer/portal/articles/481419
ASKER
Table is UTF-8
Field is VarChar(200)
Font is Tahoma
MySQL Workbench showing - École
dbForge Studio showing - École
Front end web application showing - École
MySQL dump in text file shows as UTF-8 at top.
Help?