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:
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:
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