How to display special characters properly in MySQL?

Apply OS: Windows, Mac, 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.

 

Mac

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 Advanced tab, choose the correct encoding from the Encoding drop-down menu.
Have more questions? Submit Ticket.
Have more questions? Submit a request

0 Comments

Article is closed for comments.