How to convert UTF-8 (hex) value to Unicode Character?. Trying for > a week, pls help
UTF-8 (hex) -> Unicode Character ?.
Unicode Character = “ ａ”
UTF-8 (hex) = “efbd81”
Unicode Character = “ 黪 “
UTF-8 (hex) = “e9bbaa”
I have a mySql database containing 7000+ records. In a particular column they stored all the hex values represent its respective Unicode Character like above example. I need to search the database by passing hexvalue as my search string in order to get the above Unicode Character.