Cooked Versus Raw Onion

Came here to check if anyone hates raw onion but can tolerate cooked onion. If I eat a raw onion (especially red) I'm sick to my tummy for days. White onions or shallots are ok as long as they are well cooked or sorta pickled in a salsa. If I cut an onion I can smell it on my fingers for days, so I use plastic bags.