Search condition language problem!

I have to show data for website member who's loging in.
And the data in THAI Language that can show,
But when i press search button with THAI charactors condition , It's doesn't work , How do I fix this problem ?

No answer

Hi,

SELECT column 
FROM table 
WHERE UPPER(column) LIKE ('%search%') OR UPPER(column) LIKE ('%search%') 
ORDER BY id ASC LIMIT 0, 20

I have resolve this problem!!!
It's error because php function "strtoupper"

when php convert characters to UPPER , The characters
has convert to binary or something that made query not found.

Please see attach picture.

I change a little bit search condition to use MYSQL Upper function instead strtoupper in PHP . It's work fine.

I just installed Table JX, and have the same problem in search fuction.

The search fuction works for finding numbers and alphabet. But it doesn't work in finding Japanese characters.

Could you please advise me how to fix it? I don't know which php file and syntax need to modify.

Thank in advance.
Lin