Re: name 'Szczech' returns more rows then 'Szczec%'

[Lukasz Budnik]

Hi Brendan,

On Thu, June 1, 2006 02:54, Brendan Bouffler wrote:
> I would try dumping it using 'mysqldump -c' and inspecting the insert
> statements ... seems awefully suspicious to me. I'm thinking you might
> have a line feed character (or some other invisible) in there somewhere...
>

I did just as you wrote.

I inspected the insert statements and found out that:
slect id_c, name frm clients where name like 'Szczec%'

should also return records:

id/name

4659, Szczechura
14988, Szczechowiak
24123, Szczechowski

and a few more...

ups MySQL 5.0.21 bug??

all name column values are free of \r and \n

there are 2 Szczech and they are:

30181, Szczech
30693, Szczech

name column is:

  `name` varchar(50) NOT NULL default 'NN'

and table is DEFAULT CHARSET='latin2' but as I wrote before
all those names have only latin1 characters

pozdrawiam Lukasz Budnik