This document provides a suggestion to solve the following Problem:
If you want to Export search results from SDM through the Export functionality,
and using utf8 characters in your search criteria, the Export result
might be empty or incomplete.
For example , If I search for Contacts with Last Name like '%ü%', so I am looking for people like me (Michael Müller),
I find a lot of contacts , but if I want to export this result, it fails, the result is empty!
One reason for this behavior seems to be, that the underlaying whereclause , which includes utf8 characters, is transmitted as urlencoded,
but the PDMExport Servlet running in the SDM tomcat container interpretes this data as ISO-8859-1 encoded, which is wrong in this case.
The tomcat request encoding for the PDMExport servlet can be changed to UTF-8 by the following changes to
$NX_ROOT/bopcfg/www/CATALINA_BASE/webapps/CAisd/WEB-INF/web.xml
Add behind : <!-- Add filter here -->
<filter>
<filter-name>setCharacterEncodingFilter</filter-name>
<filter-class>org.apache.catalina.filters.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<async-supported>true</async-supported>
</filter>
and add behind : <!-- Add filter-mapping here -->
<filter-mapping>
<filter-name>setCharacterEncodingFilter</filter-name>
<servlet-name>PDMExport</servlet-name>
</filter-mapping>
restart tomcat by
pdm_tomcat_nxd -c STOP
pdm_tomcat_nxd -c START
Let me know, if you face the same problem,
and if this suggestion helps in your situation as well,
and if not, let me know as well.
Thanks and regards
......Michael