MD. ROFIQUL ISLAM
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/C#, 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.
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.
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.
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.
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
Modified Date:Sunday, March 19, 2017
Md. Rofiqul Islam
M.Sc., MCTS, CEH
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.