- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the use of MySQL CHAR() function?
In MySQL, is it possible to get the character value of the given integer value based on the ASCII table?
MySQL CHAR() function is used to return the character value of the given integer value according to the ASCII table. Its syntax is as follows −
Syntax
CHAR(N,…[USING charset_name])
Here N, are the integers whose characters' values are to be retrieved.
Example
mysql> Select CHAR(65,66,67,68); +-------------------+ | CHAR(65,66,67,68) | +-------------------+ | ABCD | +-------------------+ 1 row in set (0.00 sec)
Advertisements