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