E = Ê?

[Lars Dohrenbusch]

Hello,

if have a problem with the following:

I've create a Table "files". The table looks like that:

id bigint
client_id bigint
path_id bigint
filename varchar(255)
extention varchar(10)

In the table "files", I have a row like that:

id client_id path_id filename extention
5643 1 47 Elero.xls NULL

When I try the following query

Select Count(*) from file Where filename ='Êlero.xls' And path_id = 47 And client_id = 1

the result is 1, but it must be 0, because the file "Êlero.xls" is not in the table.

When I change Count(*) with *, I get the result with filename = 'Elero.xls'.

What's wrong here?

Greetings

Lars

mysql 4.1.11
linux