Unable to save unicode characters into database

[Stivi]

Hi,

I'm working on a content management system for our website (ASP.NET project, C# language, SQL Server 2000), but I'm unable to save russian texts into the database. Table is okay, I've created an ntext column, which is able to store unicode characters.

However, if I'll look into the database field, all I'll find are questionmarks, instead of russian characters...

My datacommand looks like this:

dataCommand.CommandText = "UPDATE texts SET title = '" + TextBoxRU.Text + "';";

Can you help me with this? Is it necessary to change the command somehow?
Stivi

[Stivi]

Okay, so after a few hours of Googling, I found the solution :) Just to show the way to others with the same problem: http://www.microsoft.com/globaldev/DrIntl/columns/001/default.mspx#E6B

Anyway, the command string should look like this:
dataCommand.CommandText = "UPDATE texts SET title = N'" + TextBoxRU.Text + "';";

[possible181]

Thanks dear....i really missed that N