Fixing Unicode issues in Pentaho CDA
Recently I encountered problem when sending a query parameter with unicode text to Pentaho CDA. For these type of queries CDA returns an empty result set although there are matching items. After some research I fixed this issue by adding an additional parameter to the JDBC connection url. Now JDBC connection is like below. <DataSources> <Connection id="1" type="sql.jdbc"> <Driver>com.mysql.jdbc.Driver</Driver> <Url>jdbc:mysql://host:3306/DB?useUnicode=true&characterEncoding=UTF-8</Url> <User>user</User> <Pass>pass</Pass> </Connection> </DataSources>