水晶报表取oracle数据中文乱码

问题：水晶报表取oracle数据中文乱码

为了解决EF配置数据库连接，将Orace的ODBC包从ODTwithODAC112021升级到ODTwithODAC1120320_32bit.zip，但是问题来了，水晶报表取oracle中文数据出现乱码。

通过查网上资料，找到以下解决办法。

解决办法：

BO XIr2 is now unicode(UTF-'8'), which means multi-language support which was not there in previous versions thought it still use to display Arabic data (in our setup). 
So if your DB has chinese or Arabic character set then the DeskI reports should also display the same in respective languages. 
Not that the machine where DeskI is installed, the SQL client tools (SQL plus, TOAD etc) should fetch proper data in chinese or Arabic. 

Few more things to check 
If its Oracle and the SQL plus client is showing proper data then 
update the Oracle NLS_LANG variable in the registry key: 
HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient11g_home3 
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK 
修改上面注册表，问题解决。

Activate Unicode strings in the universe: 
1. Open the universe in Designer and go to: File > Parameters > Parameter 
2. Set UNICODE_STRINGS = yes and click replace. 

Set Unicode management to UTF8 
1. open the file: Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\cs.cfg 
2. under the <DriverDefaults> section, set <Parameter Name="Unicode">UTF8</Parameters> 

Install Asian language files 
1. On Windows XP and 2003 go to Start > Settings > Control Panels > Regional and Language Options > Advanced 
2. check to Install files for East Asian languages (and complex script if desired) 

.
_________________
BO 6.x/ BO XIr2/XI 3.1, Oracle 9i/10g//11g, SQL Server, DB2, IIS .Net/Java (Tomcat)