Unicode in Server-based Database (Hebrew, for example) while working with c# winforms

See more:

C#

SQL

WinForms

application

, +

First of all, I would like to note that this is my last chance. I have been goggeling this problem over and over again for 5 days, and no result came up. I really hope somebody will be able to solve my problem, and I would like to thank you for reading this topic.

Well, I'm working with C# winform witch hosts an element controll of xaml type. In the user controll, I'm sending information (Hebrew text) to my Server-based Database right after I click the 'send' button. The application sens question marks instead of the needed text and thats what I see when I go into the table and check the results.

I would like to note that I have already set the field to NVarChar or nText witch SHOULD accept Unicode charactes, such as Hebrew chars. If I insert the Hebrew text into the fields by myself without using the application, it doesn't show the question marks and saves the Hebrew text as it is. The problem appears only when I try to send the data from the application.

Well I've been told that this is an encode problem, and that I should add a meta tag with sets the page language to Hebrew (UTF8 or Windows-2522), but its not possible to me since I'm not using an aspx pages in my application. All the data witch should be sent is from xaml file.
Another thought was that I should run a command like "Character Set hebrew" as an sql command, but I did not mange to get this command work for me, it just crashes the application when I use the next 2 lines:

SqlCommand cmd2 = new SqlCommand("CHARACTER SET hebrew, con);
cmd2.ExecuteNonQuery();

I have read a lot of expert suggestions with this problem, but nothing really worked for me. For example, I read somewhere that I should dynamically set the database collection to hebrew, with I just don't know how, and all the manuals I read I did not find any answer for that.


To sum up, I can't let this problem go because all my application is based on the Hebrew language and I can't just ignore it, but I really don't know what else can I do in order to make this work for me.
I really hope that one of the experts here will manage to show a working solution for this problem, and I really will be glad.

Thank you for the long reading, and sorry for wasting your time :( ,

Tom