1. I have an international website which historically has used latin1. I have converted some table columns to UTF8mb4-general which has fixed the issues I had with special characters, but was wondering – should I convert the whole database or just the columns which need it?
2. I have read that setting the charset in the connection string to 'utf8mb4' makes "set names utf8mb4" redundant. Is this true?
Environment – MariaDB 10.2.9 and PHP 7.1.10 on Linux. Using PDO.