We might be starting a new project at work for a doctors surgery. But because the database will contain information such as patient notes etc. I'm worried about security.
Is it sufficiently secure to store sensitive information like this as plain text in a MySQL database? Or should we look at encrypting it in some way, bearing in mind some of the notes may be quite long.