UNICODE Function in SQL

The UNICODE function of Structured Query Language shows the unicode (integer) value of the first character of the string. We can also use the UNICODE function with the string fields of the SQL table.

Syntax of UNICODE String Function

Syntax1: This syntax uses the UNICODE function with the column names of the SQL table:

In the syntax, we have to specify the column's name on which we want to use the UNICODE string function.

Syntax2: This syntax uses the UNICODE function with the set of characters (string):

Syntax2: This syntax uses the UNICODE function with the individual character:

Examples of UNICODE String function

Example 1: The following SELECT query shows the UNICODE value of the given string:

Output:

Example 2: The following SELECT query returns the UNICODE value of @ symbol:

Output:

Example 3: The following SELECT query shows the UNICODE value of the first character of the given string:

Output:

Example 3: The following SELECT query shows the UNICODE value of the 'R' character:

Output:

Example 4: This example uses the UNICODE function with the SQL table

In this example, we are going to create a new SQL table on which we have to execute the UNICODE function for finding the UNICODE value of first character.

The syntax for creating the new table in the SQL database is as follows:

The following CREATE statement creates the Student_Grade table:

The below INSERT queries insert the records of students with grades and marks in the Student_Grade table:

The following SELECT statement displays the inserted records of the above Student_Grade table:

Query 1: The following SELECT query uses the UNICODE function with the Last_Name column of the above Student_Grade table:

This SQL statement shows the unicode value of the first character of the last name from the table.

Output:

Query 2: The following SELECT query uses the UNICODE function with the First_City, Second_City, and New_City columns of those students whose Roll_No is greater than 2 in the above Student_Grade table:

Output:

Query 3: The following SELECT query uses the UNICODE function with the First_Name column of the above Student_Grade table:

This SQL statement shows the unicode value of the first character of the first name from the table.

Output: