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

[Lukasz Budnik]

> versions for the same release series of MySQL. If you change the character
> set when running MySQL, you must run myisamchk -r -q
> --set-collation=collation_name  on all MyISAM tables. Otherwise, your
> indexes may not be ordered correctly, because changing the character set
> may also change the sort order. HTH

Thanks!!

Now it works!

Indeed I've migrated directly from MySQL 3 to MySQL 5 ;)

once again thanks for your help!

best regards
Lukasz Budnik