Saving Japanese characters as a question mark in Sql Server DB

Question

I have SQL Server Db on DiscountASP server. I created Front End on VB.net and am trying to insert values ​​into a database. It works great, except when I insert some Japanese characters, the data is stored in the form of Question marks (???). My fields in the database are of type nvarchar and before inserting into DB I do not encode / decode any strings in VB.net.

Any suggestions on how to store Japanese characters in the database and then retrieve them also in Japanese?

Answer 1

When you insert or update, you need a prefix value with N on the front panel. eg.

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

, N . =)