If I recall correctly, you can use UNICODE data type for multilanguage support, refer http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx and http://www.sqlservercentral.com/articles/Miscellaneous/globilizationinsqlserver/1946/

hth Hemantgiri S. Goswami

thank you hemant . i couldn't able to see you link . actually i want to store data in one language and fetch it in another.

In addition to UNICODE (NVARCHAR, etc), you may also want to explore the possibility of using different collations for different columns, for example, the text columns may be using a Chinese collation whereas the date can use an English collation (i.e. the Latin default)