Unicode store in ASP.NET

[Guest]

I've been recently trying to store unicode text (Farsi text) into an nvarchar column in SQL Server, using Visual Basic .NET (in an ASP.NET application). When I try to enter the data directly, from within Visual Studio .NET through the use of Server Explorer, the unicode text is stored correctly, but When I try to do the same thing executing an INSERT statement (using SqlConnection and SqlCommand objects), the data is not stored correctly. The unicode text is then displayed as question marks. Your help would be of great importance.

 

[Andrea Williams]

There may be someone better to answer this, but I used to work with Farsi
and several other langs in Classic ASP. I remember I had to have the
metatags identical on form page and display pages. So if the metatag for
the input is "UTF-8" going in, that's what it has to be going out.

Hope this helps, but as I said, I've only worked with Classic ASP on this
type of issue (so far).
Andrea

I've been recently trying to store unicode text (Farsi text) into an

nvarchar column in SQL Server, using Visual Basic .NET (in an ASP.NET
application). When I try to enter the data directly, from within Visual
Studio .NET through the use of Server Explorer, the unicode text is stored
correctly, but When I try to do the same thing executing an INSERT statement
(using SqlConnection and SqlCommand objects), the data is not stored
correctly. The unicode text is then displayed as question marks. Your help
would be of great importance.