By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
/*
-- MySQL
SELECT
UNHEX(HEX(55)),
CONV(HEX('7'), 16, 10),
CONV(HEX(SUBSTRING('56789', 3, 1)), 16, 10)
*/
-- SQL Server
SELECT
CHAR(55),
ASCII('7'),
ASCII(SUBSTRING('56789', 3, 1))
| (No column name) | (No column name) | (No column name) |
|---|---|---|
| 7 | 55 | 55 |