Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: Mismatch of column datatype between EM and QA

    I've changed the width of a column from 128 to 64. How to EM shows 64, while sysobjects and sp_help show 128 ?? Even after disconnecting and re-connecting (just to be extra sure).

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Sounds like a UNICODE datatype (nchar, nvarchar). These take up 2 bytes per character.

  3. #3
    Join Date
    Jul 2002
    Posts
    229
    Quote Originally Posted by MCrowley
    Sounds like a UNICODE datatype (nchar, nvarchar). These take up 2 bytes per character.
    Very, very true - it's a Unicode. So, EM doesn't show the "physical" width, you could say?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •