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
Moderator
http://www.SQL-Server-Performance.Com/forum
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
http://www.insidesql.de

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
http://www.insidesql.de

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
http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_dataencoding.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/intl/unicode_9i79.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_06112004.asp

Thanks for the links! I’ll add them to my library on my site –Frank
http://www.insidesql.de

]]>