Microsoft KB Archive/927923

= How to use international characters in ProClarity Dashboard Server =

Article ID: 927923

Article Last Modified on 12/5/2006

-

APPLIES TO


 * ProClarity Dashboard Server

-



INTRODUCTION
This article describes how to use international characters in ProClarity Dashboard Server.



MORE INFORMATION
To use international characters in ProClarity Dashboard Server, follow these steps:  Install the minimum required version of ProClarity Dashboard Server Service Pack 1 (SP1). The minimum required version is build 5.3.157.9509. In the Include.asp file, modify the character set that ProClarity Dashboard Server uses. Set the Microsoft SQL Server collation name of the PDS repository (PROCLARITY_PDS) to the appropriate language.

Note SQL Server supports many collations. A collation encodes the rules that govern the correct use of characters for either a language or an alphabet. For example, Macedonian and Polish are languages. Latin_General is the Latin alphabet that western European languages use.

For example, if you want to use ProClarity Dashboard Server for Greek characters, execute the following SQL statement:

ALTER DATABASE PROCLARITY_PDS COLLATE GREEK_CI_AS

If you want to use ProClarity Dashboard Server for Hebrew characters, execute the following SQL statement:

ALTER DATABASE PROCLARITY_PDS COLLATE HEBREW_CI_AS

 Modify the column types of the tables in the PDS repository.  Change char columns to nchar columns. Change varchar columns to nvarchar columns.

You must do this because the character lengths of Greek, Hebrew, Korean and other characters are longer than the default character length.</li></ol>

Keywords: kbexpertiseinter kbhowto kbinfo KB927923

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.