Is the red tide safe

I've seen the 'red tide' more times than I can recall, I've surfed in it and I've swam in it but I know for sure I'm going to have an upset stomach after doing so. I've just come back from the beach and I can't help notice that people either don't care, aren't aware or... I'm wrong about it.

can you guys enlighten me?

thanks