Character Data Types

Question 1

char
Type?
Language?
Lengths?

Answer 1

Character string
non-Unicode
fixed length max length of 8000 characters

Question 2

Varchar
Type?
Language?
Lengths?

Answer 2

Character string
non-Unicode
Variable length max length of 8000 characters

Question 3

varchar (max)
Type?
Language?
Lengths?

Answer 3

Character string
non-Unicode
variable length max length 231 characters

Question 4

text
Type?
Language?
Lengths?

Answer 4

Character string
non-Unicode
variable length max length 2,147,483,647 characters

Question 5

nchar
Type?
Language?
Lengths?

Answer 5

character string
Unicode
fixed length max length 4000 characters

Question 6

nvarchar
Type?
Language?
Lengths?

Answer 6

Character string
Unicode
variable length max length 4000 characters

Question 7

nvarchar (max)
Type?
Language?
Lengths?

Answer 7

Character String
Unicode
variable length max length 230 characters

Question 8

ntext
Type?
Language?
Lengths?

Answer 8

Character String
Unicode
Variable length max length 1,073,741,823

Question 9

Binary
Type?
Language?
Lengths?

Answer 9

Binary String
Binary
Fixed length max length 8000 bytes

Question 10

varbinary
Type?
Language?
Lengths?

Answer 10

binary string
binary
Variable length max length 8000 bytes

Question 11

varbinary(max)
Type?
Language?
Lengths?

Answer 11

Binary string
binary
variable length max length 2GB

Question 12

image
Type?
Language?
Lengths?

Answer 12

Binary string
binary
Variable length max length 2GB