Microsoft KB Archive/927923

Knowledge Base

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:

1. Install the minimum required version of ProClarity Dashboard Server Service Pack 1 (SP1). The minimum required version is build 5.3.157.9509.
2. In the Include.asp file, modify the character set that ProClarity Dashboard Server uses.
3. 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

4. Modify the column types of the tables in the PDS repository.
   1. Change char columns to nchar columns.
   2. 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.

Keywords: kbexpertiseinter kbhowto kbinfo KB927923

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.