E = Ê?
Posted by: Lars Dohrenbusch
Date: July 28, 2005 03:18AM


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?



mysql 4.1.11

Options: ReplyQuote

Written By
E = Ê?
July 28, 2005 03:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.