Chinese Character (unicode)

27 Views

Post Author: xururong

CA Forum: Crystal Reports

Hi, all

1. Source = MySQL (big5 charset)

2. Destination = MSSQL 2005 (N'DataType) Default Collation = SQL_Latin1_General_CP1_CI_AS

3. Businessobjects XI R2 SP2

Problem 1: After pulling data from mysql to mssql2005, i can see the data in unicode format, but when i'm trying to create crystal report from the db, i only able to see the unicode but not chinese, is there a way that i can view the data correctly in crystal report?

Problem 2: After i created the crystal report and saved into Enterprise, even thought in crystal report i cant see the exact chinese character, I trying to use different encoding to view it, but also failed.

Please advise me, how should i set the application whether i should do it in ms sql 2005, or maybe install language pack for crystal report xi r2 sp2, or should i change some settings in BO Enterprise XI R2 SP2?

All feedback and suggestion is welcomed, and i willing to do all kind of testing.

Thanks,

Yii Ing