How to: Fix special characters (ü or ß) when they turned into '?' in a template?

Dan Robichau

October 09, 2020 19:09

Overview

Issue

When you export your XL Release template and try to import again, all of your special characters (ü, è, ß, ó, etc.) are all transformed into a question mark ?.

Cause

This could be due to the locale settings of the user account that runs the XLR service.

Environment

XL Release

Resolution

Assuming that you are running XLR as a service, add the following to XLR_HOME/conf/xlr-wrapper-linux.conf

If you are using Oracle JDK:
```
wrapper.java.additional.7=-Dfile.encoding=UTF-8
```
If you are using IBM JDK:
```
wrapper.java.additional.7=-Dclient.encoding.override=UTF-8
```
Restart your XL Release instance
Export your template again and when you import that exported template again, you will see the special characters back in your template.

Additional Information

We tested this in XL Release version 7.6.1.