Alex Rivera | Logout

Nvarchar or varchar what is better use multiply of 2 or rounded full numbers?

Asked 2009-09-03T17:56:29.953
20

My question is what is better to use in generating columns in SQL. Should the size of nvarchar (varchar) be multiply of 2 (32, 64, 128) or it's doesn't matter and we can use fully numbers example '100', '50' ?

Thank You very much for answers with reasons

Greeting's to all

sql size varchar nvarchar
Edit
Report

1 Answer

2

There's no benefit in having size of (N)VARCHAR columns be a power of 2. Use whatever is suitable for your domain model.

answered 2009-09-03T18:00:05.313

Your Answer