problems about displaying chinese and mislocation of controls

1. I have problems on displaying chinese on reporting services.

e.g. §Cˉ×a′oà-J′?3??h?o(¤??)

The data type of the fields is char. Is it possible to display chinese using this database setting but not setting the data type to nvarchar?

2. On the other hand, there is mislocation of the controls. If I put a textbox on another textbox, one of the textbox will not be in the orginal location but in somewhere nearby. The same situation appears for the case of images. How can I "lock" the location of the controls?

I almost forgot I am assuming you know the Chinese alphabet is more than 2000 characters compared to the 26 characters Latin. I don't see how you can render Chinese with Char, you need Nvarchar or Nvarchar(max) with the version of Chinese you need because there are about six defined in SQL Server. You can use collation for the database table and column, the report dataset data option property and the international section of the table and text box. The later just change the collation of the ReportServerDB and the ReportServerTempDB. But clean collation in your tables and columns with the stored procedure will take care of it. Hope this helps.

|||

There is nothing happen when I set any collation in MS VS. As other applications are using the same database, I can't change the datatype into nvarchar.

Is nvarchar the only solution to the problem?

|||

(Is nvarchar the only solution to the problem?)

Nvarchar only tells SQL Server the data is not ASCII but Unicode it is the collation that tells SQL Server what code page to use and sort order which is very important with Chinese. You can create a View with Chinese collation and Nvarchar, then add the collation in the stored procedure run a search for collation precedence in the BOL.