Connection option in MSSQL2005

Hi,
There is a setting in option-> connection -> 'Perform translation for character data' in Query Analyzer in MSSQL 2000. Is there any option in MSSQL2005 has simliar function? Thanks in advance

(stephanielauym@.discussions.microsoft.com) writes:
> There is a setting in option-> connection -> 'Perform translation for
> character data' in Query Analyzer in MSSQL 2000. Is there any option
> in MSSQL2005 has simliar function? Thanks in advance There does not seem to. I had enough with character translation with the 6.5 tools, so I can't say that I miss it. What use would you see for such an option? -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

|||in the DB, some of the field in varchar contains chinese characters. In MSSQL2000, we un-click this option to read the chinese char.|||

(stephanielauym@.discussions.microsoft.com) writes:
> in the DB, some of the field in varchar contains chinese characters. In
> MSSQL2000, we un-click this option to read the chinese char. And you are saying that there is no way to turn transkation off in Mgmt Studio? I have it off in my QA, but I can't say whether that is the default or not. (I assumed that it was off by default, but maybe I was wrong.) What is the collation of these columns? How do they display in QA currently? If this is important for you I suggest that submit a suggetion on http://lab.msdn.microsoft.com/productfeedback/. It's a good idea to give a background why you want this. -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

|||Yes, I can't find the option which is similar to the option 'Perform translation for character data' in Management Studio. In our case, turning off this option would display chinese in varchar field.sqlsql