1.1 Convertor IPB2.0.0 to SMF = "Illegal mix of collations", help :(

[DrunkenDonkey]

SMF Version: SMF 1.1 RC2
Hi guys, I'm attempting to move to "the real" board software - smf(!) but facing problems converting my huge IPB 2.0.0 board to it, can someone give a hand?

This is the error from the convert.php taken from here:
http://www.simplemachines.org/community/index.php?topic=38966.0

Code Select Expand

Recalculating forum statistics... Unsuccessful!
This query:

    SELECT ID_BOARD, memberGroups
    FROM `smf`.smf_boards
    WHERE FIND_IN_SET(0, memberGroups);

Caused the error:

    Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'

The beta one from http://www.simplemachines.org/community/index.php?topic=65677.0 gives exactly the same error, but just has linefeeds between query lines

[DrunkenDonkey]

Just FYI - I have tried everything I found on the net including converting/setting all source and destination tables to one charset with no luck. Downgrading the mysql to 4 solved the problem.