List:General Discussion« Previous MessageNext Message »
From:Lukasz Budnik Date:June 1 2006 10:37am
Subject:Re: name 'Szczech' returns more rows then 'Szczec%'
View as plain text  
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

Thread
name 'Szczech' returns more rows then 'Szczec%'Lukasz Budnik31 May
  • Need help querying a database of polynomialsLew E. Lefton31 May
    • Re: Need help querying a database of polynomialsPeter Brawley31 May
      • Re: Need help querying a database of polynomialsPooly31 May
      • Re: Need help querying a database of polynomialsMichael Stassen1 Jun
  • Re: name 'Szczech' returns more rows then 'Szczec%'sheeri kritzer31 May
    • Re: name 'Szczech' returns more rows then 'Szczec%'Lukasz Budnik31 May
      • Re: name 'Szczech' returns more rows then 'Szczec%'Jake Peavy1 Jun
        • Re: name 'Szczech' returns more rows then 'Szczec%'Brendan Bouffler1 Jun
          • Re: name 'Szczech' returns more rows then 'Szczec%'Lukasz Budnik1 Jun
            • Re: name 'Szczech' returns more rows then 'Szczec%'Jake Peavy1 Jun
  • Re: name 'Szczech' returns more rows then 'Szczec%'Remo Tex1 Jun
    • Re: name 'Szczech' returns more rows then 'Szczec%'Lukasz Budnik1 Jun
      • Re: name 'Szczech' returns more rows then 'Szczec%'Remo Tex1 Jun
        • Re: name 'Szczech' returns more rows then 'Szczec%'Lukasz Budnik1 Jun
        • myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')Chris Sansom4 Jun
          • Re: myisamchk (was: name 'Szczech' returns more rows then'Szczec%')Chris Sansom5 Jun
          • Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')gclark5 Jun
            • Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')Chris Sansom8 Jun