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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
