Why the values returned in EM and QA is different? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Why the values returned in EM and QA is different?

I’m using Chinese (Hong Kong S.A.R) in my windows. If I run the Return all rows function in EM for a table, the return value for a column is different from the value returned in select * from that table in Query Analyzer.
Thank you for any help.
I never trust values shown on Enterprise Manager for the cross-check I will use QA as a final value, EM is meant to be flaky sometimes with GUI blip. I suggest refer the value in QA and try to retrieve the value from application for verification. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Like satya said, I would rather trust QA than EM. Your column is of an unicode datatype?

Frank, The datatype is text so it is non-Unicode.n You can see what I try to in the thread "How to handle different language?".
Thank you for any help.

Well, to be honest, I don’t have any experience with Unicode, too.
But after reading your other thread, I believe that you did something wrong. First of all I think you need to use NTEXT. Otherwise you won’t have any chance, then I would read very carefully through BOL. All I think I can do is give some links:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx for handling of BLOBs in general.
http://www.unicode.org/ is the homepage of unicode. I believe MSDN and/or TechNet will have further information. –Frank

Frank, Thank you for the link. It seems to me that there is not too much info on Unicode/International area. Also, from the responses I got from different sites, I feel that not too many people have experiences in the area. I’m reading the following MS articles: http://msdn.microsoft.com/library/en-us/dnsql2k/html/intlfeaturesinsqlserver2000.asp
Thanks for the links! I’ll add them to my library on my site –Frank