Hello all- We recently were running into a pesky problem where international characters were becoming corrupted when synced between servers via the Sync module.
It took us a while to track down the issue, but it seems to have been fixed by setting the following parameter in the mysql my.cnf file: [mysql] default-character-set=utf8 >From my understanding, this specifies the default character set to use when a >mysql client communicates with a mysql server. On the wiki page about using UTF-8 characters ( https://wiki.openmrs.org/display/docs/Using+UTF-8+Characters) it recommends setting the following parameters: [mysqld] character-set-server=utf8 collation-server=utf8_general_ci I added the default-character-set parameter to these recommendations. If anybody believes this is the wrong thing to do, please let me know. Mark _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
