Multiple Languange on Analysis Manager -
09-08-2004
, 04:56 AM
Hi,
I have created a table that contains the difference
collation (language) in each field, such as
'AreaName_CH' : Area Name in Chinese, Data Type :
nvarchar, Collation : Chinese_PRC_CI_AS
'AreaName_TH' : Area Name in Thai, Data Type : nvarchar,
Collation : Database Default (Thai)
And 'AreaName_EN' : Area Name in English, Data Type :
varchar, Collation : Database Default (Thai)
On SQL Server Enterprise Manager, there are no any
trouble. I can see the exact characters.
But after processing a dimension on Analysis Manager, the
characters in the field of AreaName_CH have been shown
with all '?' on 'Browse Dimension Data'.
Please advise me how to solve this trouble.
Thank you very much.
Kit |