Description
The default system encoding varies by regions, while the default system encoding of FineBI English version is en_US.UTF-8. Therefore, there may be garbled characters when you export Excel in FineBI due to encoding mismatch. You need to change the code of the Linux system, for instance, from zh_CN.UTF-8 to en_US.UTF-8 to avoid this problem. Modification can be categorized as global modification and partial modification.
Global Modification
Global modification works for the entire system, making the entire system adapt to the system encoding. To achieve global modification, you need to add an encoding method in the system configuration file to overwrite the default method. The command is as follows:
vi /etc/profile
Open the file, and add the following command to the last line:
export LC_ALL="en_US.UTF-8" export LANG="en_US.UTF-8"
Save the file, exit, and execute the command to make the file effective.
source /etc/profile
Partial Modification
Sometimes the code in the Linux system cannot be used globally, but only for targeted users. This means that only certain users can use this code on Linux when using FineBI. Therefore, you need to edit the configuration file of the user.
For example, to perform coding configuration for the user named wind, execute the following command:
vi /home/wind/.bash_profile
Enter the following command in the last line:
export LC_ALL="en_US.UTF-8" export LANG="en_US.UTF-8"
Then execute the source command:
source /home/wind/.bash_profile
Note: ./bash_profile is a file that each user can use to enter shell information for their own use.