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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
E = Ê?
2932
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.