Wednesday, March 7, 2012

Problem with display of International characters

Hi All,
I have a problem in displaying International characters in SQL Server 2000.
There are a few Russian characters that are displayed as '?' in query
analyzer. i have the database setup on 2 machines. On one DB server the
characters are displayed properly and on other it is shown as '?'.
The machine on which '?' are displayed, i queried syslanguages in which
'Traditional Chinese' and 'Thai' months are displayed incorrectly like small
squares.
Please let me know if there is any SQL server setting required to be changed
or it is some setup issue.
I have also checked 'Ansi to oem conversion' settings.
Thanks
Regards
Sudesh.
This is not a SQL Server problem. Try installing the supplemental language
support files.
1. From Control Panel, select Regional and Language Options
2. From the Languages tab, select the check boxes under Supplement Language
Support.
That should resolve your problem.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Sudesh" <sudesh.h@.polaris.co.in> wrote in message
news:4A4B2435-1E31-4E6A-92BA-835D87E68B13@.microsoft.com...
> Hi All,
> I have a problem in displaying International characters in SQL Server
> 2000.
> There are a few Russian characters that are displayed as '?' in query
> analyzer. i have the database setup on 2 machines. On one DB server the
> characters are displayed properly and on other it is shown as '?'.
> The machine on which '?' are displayed, i queried syslanguages in which
> 'Traditional Chinese' and 'Thai' months are displayed incorrectly like
> small
> squares.
> Please let me know if there is any SQL server setting required to be
> changed
> or it is some setup issue.
> I have also checked 'Ansi to oem conversion' settings.
> --
> Thanks
> Regards
> Sudesh.

No comments:

Post a Comment