hexcode_text
NAME
hexcode_text(): Present a Hexadecimal table for given text's charactersTYPE
ProcedureDESCRIPTION
Given a text, this procedure outputs the text's characters along with their hexadecimal values, side by side, 16 characters per row.
It serves as a utility to detect special, missing or invisible characters throughout one's text.
SYNOPSIS
hexcode_text(in txt TEXT CHARSET utf8) NO SQL
Input:
- txt: text to analyze and present
EXAMPLES
Show the hexcodes of a text:
mysql> call hexcode_text('the quick brown fox jumps over the lazy dog');
+-----------------------------------------------------------------------------------+
| >0 1 2 3 4 5 6 7 8 9 a b c d e f 0 1 2 3 4 5 6 7 8 9 a b c d e f |
+-----------------------------------------------------------------------------------+
| 74 68 65 20 71 75 69 63 6B 20 62 72 6F 77 6E 20 t h e q u i c k b r o w n |
| 66 6F 78 20 6A 75 6D 70 73 20 6F 76 65 72 20 74 f o x j u m p s o v e r t |
| 68 65 20 6C 61 7A 79 20 64 6F 67 h e l a z y d o g |
+-----------------------------------------------------------------------------------+