Wordpress DB backup doesn't seem to support special chars like ß

Martijndort

Anyone who has noticed inconsistencies when restoring a MySQL dump containing special characters like ß. Manually exporting a MySQL dump via a PHP script preserves these characters, while exporting from Enhance or using the SQL file from a backup does not.

Thomas_W

Martijndort use you the V11 or V12?
With V11 I had to restore a Database with German special characters and this worked like a charm. The tables was all UTF-8mb3_general_ci. When you restored it with latin1 it can loose the ß, because this is official in latin1 not implemented. latin1_german use the Windows 1252 charset where the ß is included. Also latin15 includes the ß.
If this is the reason, there are programs to convert the charset or you can maybe just change the SQL.