SQL Languages

[AMayer]

I am currently developing the architecture for my company's coorporate website. The site needs to be launched with both an English and Japanese version. Much of the information displayed on the site will be stored in MSSQL for easy content management.

My question is this: Can I store both English and Japanese text in the same database? I would like to just put a language field in the table so I can query either language from the same routine. If this is not possible, can I create two different databases in MSSQL and use one for each of the languages?

Any help anyone could give me would be greatly appreciated. I've been scouring the web for an answer to this and can't find much useful information on the subject of languages. Andrew

 

[flany]

Iuse sqlserver 2000 and i don't have any like this but we have searching if it was possible and YES it is (but I never seen...)
Regards
flany

 

[TomSark]

You can do this using unicode data. If you are using SQL 2000, you can even have a table that contains both Japanese columns and english columns... Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[TarunKNayak]

I am also facing the same problem. Kindly tell how to use (store and retrieve) data in multiple languages in the same table? And how exactly to use the Unicode.

Tarun. tknayak@hotmail.com