Do you have to encrypt database tables that contain PII data?

Do you have to encrypt data in a database that is PII data? Or is it enough if the servers hard drive is encrypted at rest?

If you encrypt PII data in the database, you cannot perform searches on this data.