Apply OS: Windows, macOS, Linux

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

Apply Navicat Version No.: All

 

Windows & Linux

Version 11.0 or below

Method 1:

1. In Navicat, right-click your connection and select Connection Properties.
2. Under the Advanced tab, enable Use MySQL character set.

Method 2:

1. In Navicat, right-click your connection and select Connection Properties.
2. Under the Advanced tab, disable Use MySQL character set and choose the correct encoding from the Encoding drop-down list.

Version 11.1 or above

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

 

macOS

Version 11.0 or below

1. In Navicat, control-click your connection and select Connection Properties.
2. Under the General/Advanced tab, enable Use MySQL character set and choose the correct encoding from the Encoding drop-down menu.

Version 11.1 or above

1. In Navicat, control-click your connection and select Connection Properties/Edit Connection.
2. Under the General/Advanced tab, choose the correct encoding from the Encoding drop-down menu.