Unable to save unicode characters into database

Question

Stivi 0 Light Poster

16 Years Ago

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

asp.net

2 Contributors
2 Replies
151 Views
2 Years Discussion Span
Latest Post 14 Years Ago Latest Post by possible181

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Stivi 0 Light Poster · Answer 1 · 2007-08-16T18:28:04+00:00

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 0 Newbie Poster · Answer 2 · 2009-12-29T17:24:23+00:00

possible181 0 Newbie Poster

14 Years Ago

Thanks dear....i really missed that N