Monday, March 19, 2012

Can the data viewers display Chinese characters?

Is there a way to change the font that the data viewer uses, so that the Chinese characters don't appear as boxes?

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.

No comments:

Post a Comment