Query Analyser

[Naoise]

If you have a field of length 100, type nvarchar and you view it via the Design Table interface it will show up as length 100, if you are in Query Analyser(QA) and highlight the table name and hold down ALT and hit F1 to return the design of the table it gives it as length 200, I presume this is the unicode value and if so why does QA display it in this format?

Thanks

 

[SQLSister]

Unicode values take double the storage space as varchar values. It is showing the bytes not the actual length of the value you can store in it. I presume this is becasue this is the value you need to see if you want to find out if the table is starting to approach the record size limit.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief