Character problems
Date: 01/11/07
(MySQL Communtiy) Keywords: mysql, software, database, sql, web
I am running MySQL 4.1.22 on Windows 2000, and I'm having problems with European characters.
When data is input through the software that uses it, European characters are converted into strange symbols that may or may not display properly in a web context. For instance É looks like É in the database, ü comes out as ü.
When I input the data through SQLyog, everything from the first European character to the end of the string is cut off.
I am using utf8_general_ci, which is how the software set up the database. What am I doing wrong, or what else should I be looking for?
Thanks for any help you can offer.
Source: http://community.livejournal.com/mysql/108461.html