Unicode names not displayed correctly in all deployments
GENERAL
TESTING
GENERAL
TESTING
Description
To test Unicode display and handling, we have a student assignment named "Thor Mj\u00F8lner". When doing local testing the special character shows up fine. On our QA site, though, it shows up as junk ("Mj￸lner"). Figure out the problem. (Possibly the DB setup.)
The problem was in the database being used by the Internal QA deployment. It was a MySQL 4.1 DB which had been created with a default character set of "latin1".
mysql> show create database gbmit; ... ENGINE=MyISAM DEFAULT CHARSET=latin1 ...
As a result, when the gradebook application asked for fields from the database, it was being handed bad characters. (We hadn't noticed any problems during development because when we installed our own local copies of MySQL, we said to use UTF-8 as the default for the server.)
I modified the Internal QA database:
mysql> alter database gbmit character set utf8;
Then I wiped out the Gradebook tables and reloaded the test data. The special characters seem to be showing fine now.
To test Unicode display and handling, we have a student assignment named "Thor Mj\u00F8lner". When doing local testing the special character shows up fine. On our QA site, though, it shows up as junk ("Mj￸lner"). Figure out the problem. (Possibly the DB setup.)