MySQL query with char unicode code

Question

I am having trouble finding through a MySQL table trying to find records with a character (code 200E UTF-16) in a specific column.

This particular code does not have a glyph, so it does not work when I try to insert it into my search query. Is there a way to specify characters as their corresponding code point instead of a query?

Thanks, Ben

Answer 1

Not tested, but CHAR() may work for this:

 CHAR(0x200E); 

I can’t set up a full test script right now, let us know if it works.