mysql querying a utf charset table for c returns ç

I managed to insert special characters into a table by setting the charset with

CHARSET=utf8;

Thing is, when I run the following query on the table

SELECT * FROM table WHERE word = 'francais';

it returns both "francais" and "fran├žais"!

This is not quite desirable for my situation.. I have no idea why it does this because they're just different...

Can anyone tell me how to avoid this? Would be much appreciated.

lordstyx

Answers


Try using collation, e.g.,

select *
from table
where word = 'francais' collate utf8_bin;

Need Your Help

C# and .NET 3.5 - How to launch a process using different credentials, with a hidden window, and being able to capture standard output and exit code?

c# .net .net-3.5 process credentials

I have a Windows Service developed in C# and .NET 3.5 to perform various administrative tasks throughout our 3 domains. I've got an admin account in each domain that has the necessary rights/permis...