I have created a report which shows data from a mariadb server. One of the fields shown is the name of a person.
In the my.cnf I have set the option: character_set_server=utf8.
When I open the report from the reporting server everything is fine. All characters are displayed right.
Now I want to get the same report in a transformation. I use the Pentaho Reporting output. I set the output as pdf. If I open the generated PDF all UTF-8 characters are gone. What I am doning wrong? Do I have to configure the utf8 somewhere?
I am using BI-server CE and PDI-ce 5.2.0.
Many thanks for your help.