Im wondering if it is common practice to encrypt the database contents. or is it normally left in plain text.
for example, in a databse I have, the contents is stored in plain text:
a select query would bring up "hello world", but should it be an encrypted form of "hello world" when stored?
your opinions are most welcome. In my opinion, which im not sure about, It makes it easier to transform / transport / work with while coding etc but also creates a security issue. Then again, if you encrypt thousands of records and lose the key to it, how do you recover it when its encrypted? So Im undecided, I guess it has its pros and cons..