Different sized columns from same table?

• emiddlebrooks

  Hall of Fame

  Points: 3398

  More actions

  May 23, 2003 at 10:42 am

  #80163

  Why does SQL server return different column sizes on different DB servers when doing an UPPER()?

  The two servers have the column defined the same (char(20)) and they are running the same version of SQL server (2000), but one returns a field that is 20 wide and the other 40.

• guarddata

  SSCertifiable

  Points: 6583

  More actions

  May 23, 2003 at 2:31 pm

  #458417

  Sounds like one server is defined as NCHAR and the other as CHAR. The wide character format takes two bytes per character.

  Guarddata-