More than 5 years have passed since last update.

To convert character string into hexadecimal codes string on RDB SQL

Posted at 2015-06-19

MySQL にては

SELECT HEX(string_data);
SELECT HEX(CONVERT(string_data USING UTF8));

PostgreSQL にては

SELECT ENCODE(string_data::BYTEA, 'HEX');