mysql> SELECT X'4D7953514C';
-> 'MySQL'
mysql> SELECT 0x0a+0;
-> 10
mysql> SELECT 0x5061756c;
-> 'Paul'
default type ada string. kalau nak paksa sebagai nombor, guna CAST(.... AS UNSIGNED)
mysql> SELECT 0x41, CAST(0x41 AS UNSIGNED);
-> 'A', 65
........................
tambahan:
mysql> SELECT HEX('cat');
-> '636174'
mysql> SELECT 0x636174;
-> 'cat'
ref>> http://dev.mysql.com/doc/refman/5.0/en/hexadecimal-literals.html
-> 'MySQL'
mysql> SELECT 0x0a+0;
-> 10
mysql> SELECT 0x5061756c;
-> 'Paul'
default type ada string. kalau nak paksa sebagai nombor, guna CAST(.... AS UNSIGNED)
mysql> SELECT 0x41, CAST(0x41 AS UNSIGNED);
-> 'A', 65
........................
tambahan:
mysql> SELECT HEX('cat');
-> '636174'
mysql> SELECT 0x636174;
-> 'cat'
ref>> http://dev.mysql.com/doc/refman/5.0/en/hexadecimal-literals.html