BUG: SEM Help Displays Incorrect Size Information for Unicode Columns (273593)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q273593
BUG #: 58384 (SQLBUG_70)
BUG #: 236165 (SHILOH)

SYMPTOMS

When you display the properties of a table that contain UNICODE columns in the SQL Server Enterprise Manager (SEM), the Size(Precision,Scale) column lists the number of characters that can be stored in that column, not the column size in bytes as the Help states.

WORKAROUND

Run sp_help 'tablename' to return the correct column size in bytes.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB273593
©2003 Microsoft Corporation. All rights reserved.