sql server 2008 R2-VB.net

I don't have much experience with MS SQL server 2008 R2 but here is the issue if you would help me please:
I have a table with a column/field (type : nvarchar) that stores text. The text is read from a text file and written to the database using vb.net application.
The text in the text file contains Turkish characters such as the u with 2 dots on top(in the future it will be in different languages )
When I open the table, the text in the column is not readable. It converts the Turkish special character to some unreadable characters.
Is there anyway to make the text readable in the table?
Thank you so much.

When you say "When I open the table" are you talking about in SQL Server Management Studio or in an .NET app or something else? It would obviously be useful for us to see the relevant code regardless, so we can see what you're doing and what you might be doing wrong.

I open the table in SQL server Management studio

The .net app used only writes the text in the text file to the table. If the text is only ASCII (Aa to Zz , /...) I can read it in the table from SQL Mgt Studio fine. But if it has the turkish characters, those character appear in some weird unreadable by human.
Thank you so much

Quote:

---

Originally Posted by jad0521

The .net app used only writes the text in the text file to the table. If the text is only ASCII (Aa to Zz , /...) I can read it in the table from SQL Mgt Studio fine. But if it has the turkish characters, those character appear in some weird unreadable by human.
Thank you so much

---

Then the code of the .NET app is wrong. Show us the relevant code from the .NET app, as I asked in my previous post. If I had to guess (and I do) I would say that you are using an ASCIIEncoding object to read the data when you should be using some other type of Encoding that supports the data you need to read, e.g. UncodeEncoding.