[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

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?

0
leo2007
Asked:
leo2007
  • 2
  • 2
  • 2
1 Solution
 
Reza RadCommented:
I think you must set Regional and Languages to these language in control panel and restart system and try again
0
 
leo2007Author Commented:
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?
0
 
Reza RadCommented:
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
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
pcelbaCommented:
You have to use Unicode font in C# grid.
0
 
leo2007Author Commented:
Thank you. When i converted nvarchar field column value to unicode in code behind (c#), the foreign language is rendered properly on the UI.
0
 
pcelbaCommented:
You are welcome!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now