From what I've read, when a cat is happy and content, their tail is straight up in the air and the tip of it curls.