Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Varchar vs. char
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00690420
Message ID:
00690451
Views:
14
>While I agree with you, the overhead is not enough to worry about IMO. Unless the data is fixed length, I always use nvarchar for strings.

I am pulling from BOL:

Use char when the data values in a column are expected to be consistently close to the same size.

Use varchar when the data values in a column are expected to vary considerably in size.

If is your experience that there is not much of a performance difference? Also, why nvarchar? Is Unicode that popular, or due to the fact the SET ANSI_PADDING is always ON?
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform