SQL trigger failes with post_content

I’ve written a filter for you. It will filter the character before the post get saved in the database and it’s using the WordPress way. If you use this I think you’re not gonna be needed the trigger. Here it is-

add_filter( 'wp_insert_post_data' , 'the_dramatist_filter_content_before_insert' , '99', 2 );

function the_dramatist_filter_content_before_insert( $data , $postarr ) {

    $search  = array('Â'); // You can add other replacement finding here also
    $replace = array(''); // The replacements

    $data['post_content'] = str_replace($search, $replace, $data['post_content']);

    // Now just return the data
    return $data;
}

Hope that thing helps.