LEN vs DATALENGTH Function | CHAR vs VARCHAR | VARCHAR vs NVARCHAR | VARCHAR(n) vs VARCHAR(MAX)

LEN vs DATALENGTH Function | CHAR vs VARCHAR | VARCHAR vs NVARCHAR | CHAR vs NCHAR | VARCHAR(n) vs VARCHAR(MAX) Agenda: -------- Q01. What is the difference between LEN() and DATALENGTH() in SQL? Q02. What is the difference between CHAR and VARCHAR data types in SQL? Q03. What is the difference between CHAR and NCHAR data types in SQL? Q04. What is the difference between VARCHAR and NVARCHAR data types in SQL? Q05. What does the size ’n’ define in CHAR(n) or VARCHAR(n) and NCHAR(n) and NVARCHAR(n) data types? Q06. What is Collation and how it affects the data storage size? Q07. Is the declaration of a field with VARCHAR(8500) is valid in SQL? Q08. What is the difference between VARCHAR(n) and VARCHAR(MAX) in SQL? Q09. Which data type can be used to store Unicode strings in SQL? Q10. How many characters can be stored in Varchar(10) and Nvarchar(10) type field? Q11. Can you define a field as CHAR(MAX) in SQL? Q12. Can you create an Index on a column that is