What MySQL returns if we provide value larger than 255 as argument to MySQL CHAR() function?

MySQLMySQLi Database

MySQL converts the arguments of CHAR() function which is greater than 255 to multiple result bytes. For example, CHAR(260) is equivalent to CHAR(0,1,0,4). It can be more clear with the help of following statements −

mysql> Select HEX(CHAR(256)),HEX(CHAR(1,0));
| HEX(CHAR(256)) | HEX(CHAR(1,0)) |
| 0100           | 0100           |
1 row in set (0.00 sec)

The above result set shows that CHAR(256) is equivalent to CHAR(1,0).

Published on 21-Feb-2018 08:27:58