Japanese Characters storing as Question Mark in Sql Server DB

I have a SQL Server Db on DiscountASP Server. I have created a Front End in VB.net and trying to insert the values in the Database. Its working great except when i insert some Japanese Characters, the data is stored in the form of Question Marks (???). My Fields in Database are of type nvarchar and before insertin开发者_Go百科g into DB i am not encoding/decoding any strings in VB.net.

Any suggestions on how to store Japanese Characters in DB and then Retrieve them in Japanese as well?

When doing your insert or update, you need to prefix your value with N at the front. e.g.

UPDATE thingy SET name = N'こんにちは'

Note that the N is before your single quote. That should fix it =)