SQL Server with Japanese Text

Hi Guys,

Right now I am doing a project based on Japan, and I have a problem with dealing the Japanese texts. I have already installed the multilingual supports of the Server to read the Japanese texts. I have also created an sql server script to insert the Japanese Character. But, unfortunately it's good to see in the sql script all Japanese symbol but when I hit the F5 to run the script to Insert the data, once already inserted and tried to query the data, the sql server returns "????" for all Japanese Characters. Anyone here knows how to fix this problem. Thanks in advance.

Then the language you are using to insert the Japanese text does not support Unicode or it is being converted to ANSI, e.g. using String variable to hold SQL insert query in VB.

Move to .NET, Java or any other Unicode compliant language.