The ultimate solution to the Navicat garbled problem under Ubuntu

The garbled characters of Navicat under Ubuntu can be roughly divided into two categories. One is the garbled characters of the Navicat software itself, and the other is the garbled characters after linking to the database, including editors, tables, etc. garbled characters, the following provides guidance on solving these two types of garbled characters!

Environment information: ubuntu:18.04 navicat:12.1.10

1. Navicat’s own garbled solution

Need to edit navicat’s startup script, start_navicat As shown below, just modify export LANG="zh_CN.UTF-8".

#2. Solving the garbled characters after connecting to the database

First, when connecting to the database, in the advanced options, set the encoding to UTF -8, enter the interface after successful connection.

Select Tools-Preferences, under the General tab, select "Noto Sans Mono CJK TC Regular" as the font.

Select "Noto Sans CJK SC Regular" as the editor font under the editor tab.

Select "Noto Sans Mono CJK TC Regular" for the grid font under the record page.

After the modification is completed and the software is restarted, the coding problem will be solved!

python learning network, a large number of Navicat usage tutorials, welcome to pay attention!

The above is the detailed content of The ultimate solution to the Navicat garbled problem under Ubuntu. For more information, please follow other related articles on the PHP Chinese website!