Hello to all,

I am programming a multilanguage web site. I created my Resource Provider to get the data from SQL Server Database. I tried to add some words in my database in japanese language but only save question marks (?????). My question is:

How can I program my web site to use Japanese language?

I need create a new database with Japanese language configuration?

Thanks in advance 

Is the data type NCHAR or NVARCHAR? If it is CHAR or VARCHAR then  only ASCII will be saved correctly.

ALso if you are using raw TSQL as in

INSERT INTO FRED(NAME) VALUES ('FRED FLINTSTONE')

change it to

INSERT INTO FRED(NAME) VALUES (@'FRED FLINTSTONE')

vendevelop:

I need create a new database with Japanese language configuration?

Doesn't work.

The data type is VARCHAR. I tried with this testing sentence:

INSERT INTO dbo.TableResources(Resource_Value) VALUES (@'について')

 Error:

Must declare the scalar variable "@".

Please try

INSERT INTO dbo.TableResources(Resource_Value) VALUES (N'について')

Doen't work.

The row is saved in the database but the values is ??????

Which is the best option for multilanguage website to manage several languages including Japanese? 

>The data type is VARCHAR.

Please amend data type to NVARCHAR

Great! now it's working good.

But, I will have not problem with my database in the future?

My web site will be show 40 different languages, do you think that the best option is save all text translation in one database? or will be better create another database for oriental languages like as japanese, chinese, etc? 

I need set any configuration in my database? I create my database with default values, it is OK?

I suggest you use just the one database.

 OK, thanks for your help!

My web site it's work fine.