Thanks for your response. I think it might be a cultural thing; although I've never been charged for anything myself and so have limited understanding of what that might feel like, I would never judge someone negatively for a prosecution of any crime unless they were actually sentenced. Accusations of sex offences might admittedly be less comfortable to have been known for, but if you win your case there is no (legal) way for anyone to destroy your career; the worst I can imagine happening is that family members distance themselves from you - again, a cultural and personal response, not a legal one.
At least where I am (Britain), compensation will be given if the case was deemed to have been opened without sufficient evidence, which keeps the Crown fairly honest about what they prosecute. The police have a slightly less positive record for integrity, but pro bono support is available if you are actually charged. The result of this is that you should never be left financially worse for having been prosecuted if you subsequently win your case.
Finally, you never need to tell anyone that you've been charged. Of course, people can find out if they are keen enough to do so, but I probably pass on the street dozens of people who've been charged and acquitted for crimes, but I would never know and don't need to know.
