SQLite char

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

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

  1. 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.

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