w3resource

SQLite - char() function

Description

The char(X1,X2,...,XN) function returns a string composed of characters having the unicode code point values of integers X1 through XN, respectively.

Syntax:

char(X1,X2,...,XN)

Arguments

Name Description
X1,X2, ...XN Integers whose character values (according to the ASCII table) are to be retrieved.

Pictorial Presentation

SQLite CHAR() pictorial presentation

Example: SQLite char() function

The following SQLite statement returns character values (according to the ASCII table) of the integers 67, 72, 65 and 82.

sqlite>SELECT char(67,72,65,82);

Sample Output:

CHAR

Previous: changes()
Next: coalesce()



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://w3resource.com/sqlite/core-functions-char.php