Replace decomposed saved chars in the db

replace_db_errors.sql

/*
Ersetzt alle "Decomposed" gespeicherten Umlaute (ü,ö,ä,Ö) in der Datenbank
Ersetzt alle kaputten Ligaturen (ffi) in der Datenbank

https://de.wikipedia.org/wiki/Umlaut#Unicode
*/
UPDATE THE_TABLE
SET THE_FIELD = UNHEX(
REPLACE(
  REPLACE(
    REPLACE(
      REPLACE(
        REPLACE(
          HEX(THE_FIELD)
        , 'EFAC83', '666669') /* ffi => EFAC83 => 666669 */
      , '6FCC88', 'C3B6') /* ö => 6FCC88 => C3B6 */
    , '61CC88', 'C3A4') /* ä => 61CC88 => C3A4 */
  , '75CC88', 'C3BC') /* ü => 75CC88 => C3BC */
, '4FCC88', 'C396') /* Ö => 4FCC88 => C396 */ 
) WHERE HEX(THE_FIELD) LIKE '%CC88%' or HEX(THE_FIELD) LIKE '%EFAC83%';