How to display special characters properly in MySQL?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

1. In Navicat, right-click your connection and select Edit Connection.
2. Under the Advanced tab, choose the correct encoding from the Encoding drop-down list.