Foreign, non-Latin characters within Asset Bank (UTF-8)

Newer versions of Asset Bank can handle a UTF-8 character set, meaning most characters (including non-Latin characters) can be entered into Asset Bank, remain visible within Asset Bank, and can be searched upon to return the desired result.

To configure this for your Asset Bank please ensure the following:

1/ Asset Bank Version: 3.106 or above (if you have an older version then you can contact us to arrange an upgrade)

2/ Open the file [Tomcat]\conf\server.xml in a text editor and add the attribute URIEncoding="UTF-8" to the “Connector” elements, as shown here:

<Connector port="8080" protocol="HTTP/1.1" 

connectionTimeout="20000"
redirectPort="8443"
URIEncoding="UTF-8" />

<Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8"/>

3/ Finally, if you are using the MySQL database you need to edit the database settings in database-local.properties.

Find this file in your Asset Bank folder: webapps\assetbank\WEBINF\classes\database-local.properties, open it in a text editor and ensure that database.url contains ?useUnicode=true&characterEncoding=UTF-8, for example: database.url = jdbc:mysql://127.0.0.1:3306/assetbank?useUnicode=true&characterEncoding=UTF-8

Technical

Comments

Technical

Related articles