What are the best practices for handling character encoding in MySQL databases when working with PHP?

When working with PHP and MySQL databases, it is important to ensure that character encoding is handled properly to avoid issues with special characte...