problem with restoring backup. SQL chokes on Greek characters.

[carsten888]

I just migrated to VM2 yesterday, and today was testing if my backup-restore procedure still works. It stopped working.

I tried both the sql-files produced by Akeeba backup and by PHPmyAdmin. With both the import chokes on the same row in the same table.
Table #__virtuemart_states when importing row with id 535. Thats the first row with the Greece characters in it. (in the previous version of vm those were not in there).

Code Select Expand

INSERT INTO `prefix_virtuemart_states` (`virtuemart_state_id`, `virtuemart_vendor_id`, `virtuemart_country_id`, `virtuemart_worldzone_id`, `state_name`, `state_3_code`, `state_2_code`, `ordering`, `shared`, `published`, `created_on`, `created_by`, `modified_on`, `modified_by`, `locked_on`, `locked_by`) VALUES(535, 1, 84, 0, 'ΛΕΥΚΑΔΑΣ', 'ΛΕΥ', 'ΛΕ', 0, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0);

After the import crashes, there is no error at all. The above characters get imported as this:

Code Select Expand

ΛΕΥΚÎ'Î"Î'Σ
And after that the import dies.

My database and tables online and local are both set to utf8_general_ci.

Myssql:
online: MySQL-client versie: 5.1.41
local : MySQL-client versie: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
PHPmyAdmin:
online: 3.3.2deb1ubuntu1
local: 3.4.5