mysql query for multibyte string

onnyloh · 12-03-2004, 10:18 AM

i'm doing program in C

I'm querying a multibyte string. The result was unsuccessful.

SELECT `key` FROM `table` WHERE `words`='mb' ORDER BY words DESC LIMIT 1

mb is a multibyte string.

I've try to escape all the character, but the result is the same.
thank in advanced.

Mara · 12-03-2004, 10:27 AM

What type of field is words? Also, what charset is the string. You can try to type the SELECT manually from mysql console to see if it works that way.

onnyloh · 12-03-2004, 11:50 AM

u remind me.
thank. i will try.
all are in text field.
i

onnyloh · 12-03-2004, 08:29 PM

this solve.

when dealing with mutl-byte character,
use blob field may be very helpful