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/ Edit your server.xml file (from tomcat/conf directory) to include the following attributes:
URIEncoding="UTF-8" to the Connectors on port=8080 and port=8009, as
follows:
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" URIEncoding="UTF-8" />
...
<Connector port="8009"
enableLookups="false" redirectPort="8443"
protocol="AJP/1.3" URIEncoding="UTF-8" />
...
3/ Finally, if you are using the MySQL database you need to edit the database settings in database.properties or components.xconf.
If your Asset Bank has a webapps\assetbank\WEBINF\classes\database.properties file, 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
Otherwise, open webapps\assetbank\WEBINF\components.xconf and ensure that <dburl> contains ?useUnicode=true&amp;characterEncoding=UTF-8, for example:
<dburl>jdbc:mysql://127.0.0.1:3306/assetbank?useUnicode=true&amp;characterEncoding=UTF-8</dburl>

Was this article helpful?

Yes No

Thanks for your feedback!