SQL Server Performance

Why the values returned in EM and QA is different?

Discussion in 'General DBA Questions' started by pcsql, Aug 26, 2004.

  1. pcsql New Member

    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.
  2. satya Moderator

    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.
  3. FrankKalis Moderator

    Like satya said, I would rather trust QA than EM. Your column is of an unicode datatype?


    --Frank
    http://www.insidesql.de
  4. pcsql New Member

    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.
  5. FrankKalis Moderator

    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
  6. pcsql New Member

    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





  7. FrankKalis Moderator

Share This Page