Md. Rofiqul Islam is a Software Engineer of ASA International a world renowned Microfinance Organization originated in Bangladesh. He completed B.Sc. and M.Sc. in Information & Communication Engineering (ICE) from Islamic University, Bangladesh. He is experienced in Microsoft Technology such as, ASP.Net MVC, SQL Server, and Object Oriented Analysis and Design. He is an Microsoft Certified Technology Specialist (MCTS) and Certified Ethical Hacker (CEH),he has more than 7 years of working experience in Microsoft technology.

Articles Archives
March, 2017 (1)
December, 2016 (1)
November, 2016 (1)
October, 2016 (1)
September, 2016 (1)
August, 2016 (1)
December, 2015 (1)


SQL Server DataTypes the best pactice

If your database will not be storing multilingual data you should use the varchar datatype instead. The reason for this is that nvarchar takes twice as much space as varchar.

Basically you need to decide based on what support and extensibility yoy may provide today and tomorrow.

What makes VARCHAR popular is that values less than fifty characters take less space. Only enough space to hold the value is allocated. This differs from the CHAR data type which always allocates the specified length, regardless of the length of the actual data stored.

The VARCHAR datatype can typically store a maximum of 8,000 characters. The NVARCHAR datatype is used to store Unicode text. Since UNICODE characters occupy twice the space, NVARCHAR columns can store a maximum of 4,000 characters.

The advantage NVARCHAR has over VARCHAR is it can store Unicode characters. This makes it handy to store extended character sets like those used for languages such as Kanji.

If your database was designed prior to SQL 2008, you’ll most likely encounter VARCHAR; however, more modern databases or those global in nature tend to use NVARCHAR.

Modified Date:Sunday, March 19, 2017
Share on

Md. Rofiqul Islam
Software Engineer, Bangladesh.
I am a learner throughout my life. I have completed BSc & MSc in Information & Communication Engineering from Islamic University, Bangladesh. I am having over 7 years of working experience in Microsoft Technology. I'm fond of learning through sharing knowledge.
Copyright © 2018 Md. Rofiqul Islam, Email: