Correct Values MySQL doesn't understand due to encoding issues

migrateAccessToMYsql_B.vba

' Correct values, mysql doesn't understand due to encoding issuses
Private Function cleanValue(value As String) As String
    value = IIf(IsNull(value) Or value = "", 0, value)
        
    value = Replace(value, "%", " percent ")
    value = Replace(value, "‰", "permill")
    value = Replace(value, "'", "")
    value = Replace(value, "°", "deg")
    value = Replace(value, ">=", "geq.")
    value = Replace(value, "<=", "leq.")
    value = Replace(value, "=", "eq.")
    value = Replace(value, "<", "")
    value = Replace(value, ">", "greater")
    value = Replace(value, vbTab, " ")
    value = Replace(value, "€", "euro")
    value = Replace(value, vbNewLine, " ")
      
    cleanValue = value
End Function