What is N in nvarchar? – Interview Question of the Week #301

Question: What is N in nvarchar?

Answer: n in nvarchar or nchar stands for world national.

The ISO synonyms for nchar are national char and national character. The ISO synonyms for nvarchar are national char varying and national character varying. Well that we know that N stands for the national, here is one more question for you.

What does n stand for varcharmax(n)?

Well, the answer is again very simple. Here n in (n) stands for string length in byte-pairs and not a number of characters (a common misconception).

Well, that’s it. I have covered not one but two questions in today’s blog post.

Let me know what you think of this video. Here are my few recent videos and I would like to know what is your feedback about them.

If you want me to create a video on any other topic, please let me know and I will be happy to create the same and will give you credit for it. Here is a link to YouTube.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Exit mobile version