Skip to main content


1. CHAR Function

The CHAR function in H2 database is used to convert an ASCII code or Unicode code point to its corresponding character.

2. Syntax

The syntax for the CHAR function in H2 database is as follows:



  • code: The ASCII code or Unicode code point for which the character needs to be retrieved. It should be a numeric value.


  • The CHAR function returns the character corresponding to the given code.

3. Notes

  • The CHAR function in H2 database supports both ASCII codes and Unicode code points. However, it is recommended to use Unicode code points for better compatibility and support for a wider range of characters.
  • If the input code is not a number or exceeds the valid code range, the CHAR function will return NULL.
  • Make sure to provide the correct code to retrieve the desired character.

4. Examples

Here are a few examples demonstrating the usage of the CHAR function in H2 database:

Example 1 - Retrieving character for ASCII code:

SELECT CHAR(65) AS character;



Example 2 - Retrieving character for Unicode code point:

SELECT CHAR(9731) AS character;



Example 3 - Retrieving characters for a range of code points:

SELECT CHAR(9786) AS smiley, CHAR(9829) AS heart, CHAR(128516) AS emoji;


smiley | heart | emoji
☺ | ♥ | 😄
  • ascii - Convert character to ASCII code
  • UNICODE - Convert character to Unicode code point