Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-08 Thread Chris Sansom
I wrote: My problem isn't quite the same as the original poster's, but I suspect the solution may be the same. However, I'm having trouble running the myisamchk command. I'm using the Unix Terminal in Mac OS X, with MySQL 5.0.19, and it won't let me get beyond a certain point in the

myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-04 Thread Chris Sansom
At 14:02 +0300 1/6/06, Remo Tex wrote: If you change the character set when running MySQL, you must run myisamchk -r -q --set-collation=collation_name on all MyISAM tables. Hi My problem isn't quite the same as the original poster's, but I suspect the solution may be the same. However, I'm

Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-04 Thread Chris Sansom
At 18:34 +0100 4/6/06, Chris Sansom wrote: I'm stumped! How exactly do I go about this? It's OK - I sorted it out. Turns out I needed to use upper case for the .MYI. Doh! -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Old professors never die; they just lose their

Re: myisamchk (was: name 'Szczech' returns more rows then 'Szczec%')

2006-06-04 Thread gclark
At 14:02 +0300 1/6/06, Remo Tex wrote: If you change the character set when running MySQL, you must run myisamchk -r -q --set-collation=collation_name on all MyISAM tables. Hi My problem isn't quite the same as the original poster's, but I suspect the solution may be the same. However, I'm