Advertisement
javsmo

Untitled

Feb 11th, 2015
377
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. mysql> select word, hex(word) from oldword where word = 'hua';
  2. +--------+--------------+
  3. | word | hex(word) |
  4. +--------+--------------+
  5. | hũa | 6875CC8361 |
  6. | huã | 6875C3A3 |
  7. | hua | 687561 |
  8. | hũã | 6875CC83C3A3 |
  9. +--------+--------------+
  10. 4 rows in set (0,04 sec)
  11.  
  12. mysql> select word, hex(word) from oldword where word like 'hua';
  13. +-------+------------+
  14. | word | hex(word) |
  15. +-------+------------+
  16. | huã | 6875C3A3 |
  17. | hua | 687561 |
  18. +-------+------------+
  19. 2 rows in set (0,04 sec)
  20.  
  21. mysql> select word, hex(word) from oldword where word like 'hua%';
  22. +----------+------------------+
  23. | word | hex(word) |
  24. +----------+------------------+
  25. | huamanal | 6875616D616E616C |
  26. | huã | 6875C3A3 |
  27. | hua | 687561 |
  28. +----------+------------------+
  29. 3 rows in set (0,07 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement