In the book, the character was sincere. He really did try to see both sides and get along with people. It never seemed to work.

To answer the original question; a good term would be ‘two-faced.’ Someone who pretends to be a friend and then gossips about you with others.

‘Wishy-washy’ is a person who simply goes along with the majority without having strong opinions of their own.