The data viewer displays Chinese characters as boxes, something similar to [_], at least on a computer with the following regional settings.
get-wmiobject CIM_OperatingSystem | ft OSLanguage, CodeSet, Locale
OSLanguage CodeSet Locale
- -
1033 1252 0409
The data itself is flowing correctly into the target database with a pipeline data_type of DT_WSTR. The ideograms can be seen by query utilities which supports a unicode font (e.g. Management Studio).
Yes, follow
Tools > Options > Environment > Fonts and Colors, then
select Show settings for: Business Intelligence Data Viewers.
Now select the font you want to use.|||Thanks a lot Michael, works great.