hi, we had maintain client data in chiness language(some columns date like username, address..,.). example table lineid UserName Type 3 曹书魁 Server 4 侯瑞祥 Manager now, we want to display username in english using query. is it possible in sql server 2008 r2 please help me.
SQL Server doesn't provide any direct translation API so you will have to use some external translation service. The best place where to handle this using an external translation service will be GUI as the calls to the translation service will not slowdown the queries and you can translate only the displayed names. Also it could be possible to do this directly in the query eg. using CLR Scalar function. This function can take the chinese text and call some translation service and return the translated text. However as I have mentioned this will have drastical impact on the SQL Server performance especially on large datasets.