Link to home
Start Free TrialLog in
Avatar of leo2007
leo2007Flag for Canada

asked on

nvarchar field value is not displayed correctly on webpage

I have a table  (MS SQL 2005) which has a nvarchar field column which support product detail in different languages. When i enter a product description in foriegn language (eg: Chinese). It save it correctly. However when i display the same value on the UI (C# - grid) , it displays ??? and square boxes.
When i query the table, the data looks correct - i can see the chinese desc.

What is happening here..how do i fix the UI. Does it need any conversion in the code behind?

Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

I think you must set Regional and Languages to these language in control panel and restart system and try again
Avatar of leo2007

ASKER

I am not sure I understood your point.  User can enter the product description in any language. Also, u mean restart the machine which runs the application or sql server?
I mean application side,
you said that data saved correctly in DB, but doesn't show correctly in application.
I propose to you that change regional and language in application machine and try again
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leo2007

ASKER

Thank you. When i converted nvarchar field column value to unicode in code behind (c#), the foreign language is rendered properly on the UI.
You are welcome!