String data types in SQL

In this chapter you will learn:
What is string data type?
Types of string data type

What is string data type?

The data type which store the value in the form of string, word or character is called string data type. There are so many string data types that are used in sql to store different string value. Here you will get string data types in the below given table.

Data types Range Used to store Storage (Bytes)
char(n) n characters, where n can be 1 to 8000 Fixed length character data n
varchar(n) n characters, where n can be 1 to 8000 Variable length character data n+2
text Maximum length of 2^31-1 (2,147,483,647) characters Character string Variable size
ntext Maximum length of 2^30-1 (1,073,741,823) characters Variable length Unicode data Variable size
bit 0 or 1 Integer data with 0 or 1 Variable size
image Maximum length of 2^31-1 (2,147,483,647) bytes Variable Length binary data to store images Variable size
real -3.40E + 38 to -1.18E-38, 0 and 1.18E-38 to 3.40E + 38 Floating Precision number 4
binary Maximum length of 8000 bytes Fixed length binary data n (length of data)
varbinary Maximum length of 8000 bytes Variable length binary data n (length of data) +2
tinytext Maximum length of 255 characters Character string Variable size
nchar Maximum length of 4000 characters Fixed length Unicode data n (length of data) * 2
nvarchar Maximum length of 4000 characters Variable length Unicode data n (length of data) * 2+2
varchar(max) Maximum 1,073,741,824 characters Variable width character string 2 bytes + number of chars
nvarchar(max) Maximum 536,870,912 characters Variable width Unicode string Variable size
blob Up to 65,535 bytes of data Binary Large OBjects 65,535
mediumblob Up to 16,777,215 bytes of data Binary Large OBjects 1,67,77,215
longblob Up to 4,294,967,295 bytes of data Binary Large OBjects 4,29,49,67,295
mediumtext Maximum length of 16,777,215 characters Character string Variable size
longtext Maximum length of 4,294,967,295 characters Character string Variable size
SUMMARY In this chapter you have learned about string data type and its values. In the next chapter you will study about what is number data types and how many number data types are available in SQL?
 

Share your thought