Hi all, have a question regarding the open source data quality tool and hope someone can help:


Environment:

Windows 7 Pro x64
SQL Server 2008 R2
JDK 6u32 32 bit
Talend Open Studio for DQ 5.1 32 bit


The issue is that Chinese characters don't display correctly, either in the data preview component or when exporting the valid/invalid rows. Only garbage characters are shown.

The quality check itself works (for example if I specify that Country = ‘中国’ as the where clause, it gives me the right % of valid/invalid rows, but when I export the rows to view them, it’s garbage.)


I've tried the following connection strings with no luck:

jdbc:jtds:sqlserver://localhost:1433/TestDB;characterEncoding=utf-8
jdbc:jtds:sqlserver://localhost:1433/TestDB;characterEncoding=utf8


Does anyone know if there is a setting that I'm missing or is this a bug? The data viewers in native SQL Server Management Studio and Pentaho all work fine, I'm only having this issue right now in Talend.

Screenshots are attached of the issue and of my connection settings.

Thanks!