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.

Signature
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
> Hi All,
>
[quoted text clipped - 14 lines]
>
> I have also checked 'Ansi to oem conversion' settings.