{"type":"doc","content":[{"type":"panel","attrs":{"panelType":"warning"},"content":[{"type":"paragraph","content":[{"text":"This page is outdated and no longer receives updates!","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Requirements for Using UTF-8","type":"text"}]},{"type":"paragraph","content":[{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" Use any OpenMRS version 1.6 and beyond. These version have also been fixed: 1.5.1, 1.4 Beta 2 (aka 1.4.0.22), or 1.3.4 (See ","type":"text"},{"text":"ticket:965","type":"text","marks":[{"type":"link","attrs":{"href":"http://dev.openmrs.org/ticket/965"}}]},{"text":", ","type":"text"},{"text":"ticket:365","type":"text","marks":[{"type":"link","attrs":{"href":"http://dev.openmrs.org/ticket/365"}}]},{"text":", ","type":"text"},{"text":"ticket:1539","type":"text","marks":[{"type":"link","attrs":{"href":"http://dev.openmrs.org/ticket/1539"}}]},{"text":", ","type":"text"},{"text":"ticket:1943","type":"text","marks":[{"type":"link","attrs":{"href":"http://dev.openmrs.org/ticket/1943"}}]},{"text":" for updates)","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Modify Hibernate Database Connection URL","type":"text"}]},{"type":"paragraph","content":[{"text":"Modify the database URL connection so it would know that we're passing UTF-8 char.","type":"text"}]},{"type":"paragraph","content":[{"text":"Add this string into your connection.url in your ","type":"text"},{"text":"runtime properties","type":"text","marks":[{"type":"link","attrs":{"href":"http://archive.openmrs.org/wiki/Overriding_OpenMRS_Default_Properties#Runtime_Properties"}}]},{"text":" file.","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n&useUnicode=true&characterEncoding=UTF-8\n","type":"text"}]},{"type":"paragraph","content":[{"text":"The connection will become something like this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\nconnection.url=jdbc:mysql://localhost:3306/openmrs_test?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8\n","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Modify Tomcat Server Configuration","type":"text"}]},{"type":"paragraph","content":[{"text":"From ","type":"text"},{"text":"Tomcat UTF-8","type":"text","marks":[{"type":"link","attrs":{"href":"http://wiki.apache.org/tomcat/Tomcat/UTF-8"}}]}]},{"type":"paragraph","content":[{"text":"Modify Tomcat's server.xml file and add the following attribute to the connector tag:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\nURIEncoding=\"UTF-8\"\n","type":"text"}]},{"type":"paragraph","content":[{"text":"The end result would be something like this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n\n","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Modify MySQL configuration","type":"text"}]},{"type":"paragraph","content":[{"text":"From ","type":"text"},{"text":"MySQL: Configuring the Character Set","type":"text","marks":[{"type":"link","attrs":{"href":"http://dev.mysql.com/doc/refman/5.0/en/charset-applications.html"}}]}]},{"type":"paragraph","content":[{"text":"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:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\nCREATE DATABASE openmrs\nDEFAULT CHARACTER SET utf8\nDEFAULT COLLATE utf8_general_ci;\n","type":"text"}]},{"type":"paragraph","content":[{"text":"Add the following lines to the \"[mysqld]\" and \"[mysql]\" sections of the MySQL configuration file, adding the sections if necessary. For Ubuntu, the file is located in /etc/mysql/my.cnf.","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n[mysqld]\ncharacter-set-server=utf8\ncollation-server=utf8_general_ci\n\n\n[mysql]\ndefault-character-set=utf8\n","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"For interested developers","type":"text"}]},{"type":"paragraph","content":[{"text":"These are the changes we had to make to our code:","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Modify OpenMRS Web Configuration","type":"text"}]},{"type":"paragraph","content":[{"text":"Added the following line to OpenMRS web.xml:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n\ncharsetFilter\norg.springframework.web.filter.CharacterEncodingFilter\n\nencoding\nUTF-8\n\n\nforceEncoding\ntrue\n\n\n\ncharsetFilter\n/*\n\n","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Modify OpenMRS Header File","type":"text"}]},{"type":"paragraph","content":[{"text":"Added the following as the first line in headerFull.jsp and headerMinimal.jsp:<%@ page pageEncoding=\"UTF-8\" contentType=\"text/html; charset=UTF-8\" %>","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Check the current setting","type":"text"}]},{"type":"paragraph","content":[{"text":"To confirm the current character set, modify maintenance/systemInfo.jsp by adding these lines:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n\nDefault Locale\n<%= java.nio.charset.Charset.defaultCharset() %>\n\n","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Modified Controller to make correct urls","type":"text"}]},{"type":"paragraph","content":[{"text":"Modify the AddPersonController.java: 23","type":"text"}]},{"type":"paragraph","content":[{"text":"Fromreturn \"?addName=\" + name + ...","type":"text"},{"type":"hardBreak"},{"text":"\nToreturn \"?addName=\" + URLEncoder.encode(name, \"UTF-8\") + ...","type":"text"},{"type":"hardBreak"},{"text":"\nNotice the \"name\" needs to be explicitly encoded because the function will return the redirection URL to the client. Other similar pattern will also need to be encoded as necessary.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Messages.properties files","type":"text"}]},{"type":"paragraph","content":[{"text":"You can now directly put unicode characters into messages_XX.properties. You no longer have to type unicode codes into strings (remember how these files used to be full of \\u00E9, for example?). The key, however, is to make sure that your file editor encodes the messages_XX.properties file using UTF-8. If you open messages_fr.properties in eclipse, and you see garbage, change the default character encoding of your editor, or try a different application like Notepad++, if necessary.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"java.util.Properties","type":"text"}]},{"type":"paragraph","content":[{"text":"The java Properties class has two methods (load() and store()) that don't support UTF-8, that were used in a couple of places, most notably when loading message string files. There are now alternate methods that you can use in OpenmrsUtil that preform the same function, but read and write using UTF-8.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Reading in UTF-8 files","type":"text"}]},{"type":"paragraph","content":[{"text":"There is an interested Java issue involving reading in a UTF-8 file. Some applications (including Microsoft Notepad) add a special character called a byte order mark to the beginning of a UTF-8 file, but Java's standard encoding doesn't support this:","type":"text"}]},{"type":"paragraph","content":[{"text":"http://bugs.sun.com/view_bug.do?bug_id=4508058","type":"text","marks":[{"type":"link","attrs":{"href":"http://bugs.sun.com/view_bug.do?bug_id=4508058"}}]}]},{"type":"paragraph","content":[{"text":"A workaround that *appears* to fix the issue (I haven't done serious testing) is to wrap a file input stream in an org.apache.velocity.io.UnicodeInputStream instance, which is specifically designed to be BOM-aware. (There is also a BOMInputStream in apache.commons.io, but in a later version of the jar than is included in Openmrs 1.6).\n","type":"text"},{"type":"hardBreak"}]}],"version":1}

Browser not supported