Overview
The text data type is a UTF8-encoded text with Unicode support, which stores a sequence of characters (text).Examples
Let’s create an employee table with a text data type in each column:Insert the text value between the single quotes ’ ’.
Text With SUBSTR Function
Thesubstr()
function extracts a specific number of characters from a text.
Syntax
text
is the specified text.start_position
is used as the starting position, specifying the part from which the substring will be returned. It is written as an int value.length
is used to determine the number of characters to be extracted. It can be one or more characters.
The first position in the
text
is 1.Example
Insert a value into the text column.Text With LENGTH Function
Thelength()
function returns the number of characters in a text.
The number of characters might be different from the byte length.
Syntax
The length function will take a text as a parameter.Example
Insert a value into the text column.The
length()
function will also count spaces.