BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
varchar
|
|
|
nvarchar
|
|
|
char
|
|
|
to publish
|
Detailed explanation-1: -Char. Char is used to storing single character values, including numerical values. If you create an array of the character data type, it becomes a string that can store values such as name, subject, and more.
Detailed explanation-2: -The NVARCHAR data type stores character data in a variable-length field. Data can be a string of single-byte or multibyte letters, digits, and other characters that are supported by the code set of your database locale.
Detailed explanation-3: -Use nvarchar when the sizes of the column data entries vary considerably. Use nvarchar(max) when the sizes of the column data entries vary considerably, and the string length might exceed 4, 000 byte-pairs.
Detailed explanation-4: -varchar is used for non-Unicode characters only on the other hand nvarchar is used for both unicode and non-unicode characters.