How to solve navicat garbled characters

[1].Completely garbled code problem

I recently installed Navicat on the ubuntu system, and at first I found that It's a garbled box.

I looked for related blogs on the Internet, and the general solution is: find the start_navicat file in the software installation directory, as shown in the picture:

Then nano start_navicat will display the file content. At this time, change the encoding format to zh_CN, as shown in the figure:

Then Ctrl X, Y, Enter to save. At this time, restart the software and the completely garbled problem will be solved.

Then if there are garbled characters in the software, press "Tools"->"Options". The encoding issues in the software are generally set here.

In "General", change " Change "Interface Font" to Noto Sans Mono CJK TC Regular

In "Editor", change "Editor Font" to Noto Sans CJK SC Regular

Related recommendations: " Navicat for mysql usage graphic tutorial》

[2]. Table data garbled problem

***In "Record", change the grid font Changed to Noto Sans Mono CJK TC Regular.

I have tried the above fonts one by one, and there should be many others that are effective.

[3]. Query window box garbled problem

After solving the problem of complete garbled characters, I connected the mysql database, method: Connect-> MySQL, and then The following window appears:

The connection name is arbitrary, the local host is localhost, enter the user name and password, test the connection first, and press the OK key after success.

Then click "New Query" and find that garbled characters appear when entering the sql code (as shown at the cursor).

In order to solve this problem, you need to right-click the database test first, and then click "Edit Connection", as shown below:

# #Select "Advanced" in the pop-up window, and you will see "Encoding", from which you can select the appropriate encoding, such as "UTF-8".

# In this way, the garbled characters in the editing part of the new query will be solved.

The above is the detailed content of How to solve navicat garbled characters. For more information, please follow other related articles on the PHP Chinese website!