Skip to main content

stringencode

1. STRINGENCODE Function​

The STRINGENCODE function in H2 database is used to encode a string using a specified character encoding.

2. Syntax​

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

STRINGENCODE(string, encoding)

Arguments​

  • string: The string that needs to be encoded. It should be a valid string value.
  • encoding: The character encoding to be used for the encoding process. It should be a string value representing a valid character encoding.

Return​

  • The STRINGENCODE function returns the encoded string.

3. Notes​

  • The STRINGENCODE function in H2 database encodes the input string using the specified character encoding. Common character encodings include UTF-8, ISO-8859-1, etc.
  • If the specified encoding is not supported by the H2 database, an error will be thrown.
  • The output of the STRINGENCODE function is of type BINARY. If you need to convert it back to a string, you can use the CAST function.
  • Make sure to use the correct character encoding to decode the encoded string using the appropriate decoding function.

4. Examples​

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

Example 1 - Encoding a string using UTF-8:​

SELECT STRINGENCODE('Hello, world!', 'UTF-8') AS encoded_string;

Output:

encoded_string
--------------
Hello, world!

Example 2 - Encoding a string using ISO-8859-1:​

SELECT STRINGENCODE('H2 Database', 'ISO-8859-1') AS encoded_string;

Output:

encoded_string
--------------
H2 Database

Example 3 - Encoding a string stored in a column:​

CREATE TABLE messages (
  id INT PRIMARY KEY,
  content VARCHAR(100),
  encoding VARCHAR(20)
);

INSERT INTO messages VALUES (1, 'Hello', 'UTF-8'), (2, 'World', 'ISO-8859-1');

SELECT id, content, encoding, STRINGENCODE(content, encoding) AS encoded_string
FROM messages;

Output:

id | content |  encoding   | encoded_string
---+---------+-------------+----------------
1  | Hello   | UTF-8       | Hello
2  | World   | ISO-8859-1  | World
  • stringdecode - Decode an encoded string using a specific character encoding.