How to store symbols like sigma, integral etc in sql server 2000

[Jesu Prabhu J]

Plzzzzzz help me out with this problem, i have to store special symbols like integral, sigma, pi etc in tha database. I'm using the nvarchar datatype, but getting unexpected results.. Thanks in advance...........

[razov]

I think using nvarchar should be sufficient. Although you'll not be able to see these characters in 'Query Analyzer' or 'Enterprise Manager' (you will see boxes instead) but when this data is called by client application e.g. C# you can see correct depiction of the character.

Razov

[Jesu Prabhu J]

I am viewing these values in a rich textbox, but it displays ?? when the application is run.I'm using VB.net 2008

[razov]

Is your VB.NET project Unicode enabled?

Razov

[Jesu Prabhu J]

How do one check if VB.net project is Unicaode enabled, Plzzzz help..

[razov]

Click Advanced Save Options Encoding should be Unicode (UTF-8).

Razov

[Jesu Prabhu J]

Firstly i thank u,for the help. Again i am facing the problem, there is no Advanced Save Options under the File menu...

[razov]

Try Save As option for solution there you can check for Encoding option.

Razov

[Jesu Prabhu J]

Thanks a ton, for ur timely help. Looking forward for your help in future also... Bye n Thanks once more..

modified on Tuesday, September 16, 2008 6:30 AM