Change JDK default encoding to solve dbeaver garbled problem

Source: Internet
Author: User

Before, after adding a Chinese character comment in DBeaver, after choosing Save As, the commented Chinese character appears garbled?

Workaround: Add the java_tool_options option to the environment variable, add the parameter-dfile.encoding=utf-8-duser.language=en-duser.country=us, so the JDK prompts are in English, The system output of the Chinese can also be displayed normally, for the Java/scala program, Python also has a similar environment variable pythonioencoding.

dbeaver download
With the changes here, basically no more garbled appearance.
The following is why there is garbled problem?

export database dbeaver
First of all, garbled problem, not the problem cannot be solved. Everybody, don't panic. Garbled problems are caused by different character sets.
A more professional point is: computer coding (character set). Computer coding is the way computers represent letters and numbers (computers don't know our language.) Only 0 and 12 characters are known. This requires that the computer code be converted to 0 and 1. So that we do not use the computer to learn the bottom of the computer jerky low-level language (such as the Assembly), only need to be familiar with the simple keyboard input, the computer completed its own information from input to output, the results presented to us.

dbeaver vpn
Common encoding methods are: ASCII encoding, GB2312 encoding (Simplified Chinese), GBK,BIG5 encoding (Traditional Chinese), ANSI encoding, dbeaver csv driver UNICODE,UTF-8 encoding, etc.
Let's talk about the origins of these. Earliest. The computer is used in the American universities. It is enough for the Americans to enter the characters on the keyboard. So the ASCII encoding was born, and the disk was small. ASCII encoding consumes only one byte (8 bits). Later, Americans want to use computers all over the world. However, every country has its own words. The whole world can not be used in English. So the threshold of computer so high, you let not English personnel, how to do? Then there is the later Gbk,utf-8 and other computer code. Their production, yes the computer can be the majority of the world's language and text are included in. Today, the Chinese can enter Chinese on the computer. Germans can enter German. Koreans can use Korean to operate their computers. Of course, this is due to the increase in hard disk storage space. These computer encodings now account for 2 bytes (16 bits).
Now, tell me why it's garbled.

dbeaver stored procedure
As the number of computer codes (character sets) increases, the number of character sets available to you is increased. All caused by it. The default choice for computer encoding (character set) for various software and systems is different. This is the source of garbled characters.

dbeaver sql client
Because different sounds have distinct effects in different languages. The same applies to different characters under different computer codes (character sets) that produce effects differently.

dbeaver create table sql
Make an analogy: who is the meaning of the WHO in English. Hu in Chinese is a window-user. There is also the abbreviation for Shanghai (HU). This example is clear. The effect of different characters in different character sets.

dbeaver mysql public key retrieval is not allowed

Change JDK default encoding to solve dbeaver garbled problem


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.