How can we help you today? How can we help you today?

Wrong size shown in candidate list for nvarchar columns.

I'm using SQL Management Studio and SQL Server 2005. I have several columns that are nvarchar(50) but show up in the candidate list as nvarchar(100). Technically not a real problem except when using the candidate list as a reference for creating parameters etc....

Thanks,
Dave
VisualDragon
0

Comments

2 comments

Sort by
  • Tilman
    Hi Dave,

    I'm afraid I couldn't reproduce your problems. Could be that you changed the columns without refreshing the SQL Prompt cache?

    Regards,

    Tilman
    Tilman
    0
  • VisualDragon
    Hi Tilman,

    See screen shot here:
    http://www.totzke.ca/sqlprompt.jpg

    I cleared the cache and closed all current connections. The problem still exists. All columns that are nvarchar(50) were created as such originally and display in SQL Prompt as nvarchar(100). You will see a column now that is nvarchar(300) and SQL Prompt shows it as nvarchar(600).

    It is likely that SQL Prompt is relying on the column length which for nvarchar columns shows up as double because of their support for DBCS.

    Dave
    VisualDragon
    0

Add comment

Please sign in to leave a comment.