# CHAR

Processes each argument `N` as an integer and then returns a string consisting of the characters representing the code values of those integers.

## Syntax

```sql
CHAR(N [ ,... ] [ USING character_set_name ])

```

## Arguments

* Integer

## Return Type

* Binary string

## Remarks

`CHAR()` returns a binary string by default. To return a string in a different character set, use the optional `USING` flag.

## Examples

```sql
SELECT CHAR(101);

```

```output

+-----------+
| CHAR(101) |
+-----------+
| e         |
+-----------+

```

```sql
SELECT CHAR(77, 101, 109, 83, 81, 76);

```

```output

+---------------------------+
| CHAR(77,101,109,83,81,76) |
+---------------------------+
| MemSQL                    |
+---------------------------+
1 row in set (0.06 sec)
```

```sql
SELECT CHARSET(CHAR(189));

```

```output

+--------------------+
| CHARSET(CHAR(189)) |
+--------------------+
| binary             |
+--------------------+
1 row in set (0.06 sec)
```

```sql
SELECT CHARSET(CHAR(189 USING utf8));

```

```output

+-------------------------------+
| CHARSET(CHAR(189 USING utf8)) |
+-------------------------------+
| utf8                          |
+-------------------------------+
1 row in set (0.06 sec)
```

## Related Topics

* [CHARSET](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/charset.md)

***

Modified at: September 20, 2024

Source: [/db/v9.1/reference/sql-reference/string-functions/char/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/char/)

(An index of the documentation is available at /llms.txt)