Requirements for Using UTF8
NOTE: Use OpenMRS version 1.6+, 1.5.1, 1.4 Beta 2 (aka 1.4.0.22), or 1.3.4 (See ticket:965, ticket:365, ticket:1539, ticket:1943 for updates)
...
...
Modify Hibernate Database Connection URL
...
Add this string into your connection.url in your runtime properties file.
| Code Block |
|---|
&useUnicode=true&characterEncoding=UTF-8 |
The connection will become something like this:
| Code Block |
|---|
connection.url=jdbc:mysql://localhost:3306/openmrs_test?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 |
Modify Tomcat Server Configuration
...
From MySQLConfiguring the Character Set
Make sure that your mysql installation is setup to use UTF-8, which is not necessarily the default character set in a mysql installation. To create the openmrs database such that its tables will use a given international default character set and collation for data storage, use a CREATE DATABASE statement like this:
...