I am a man-level character in Oracle, so I have encountered many problems. In the last few days, oracle data queries have encountered a strange phenomenon. A database is running on a different computer and in the same environment when pl/SQL is enabled for queries. This is normal and garbled. I feel very puzzled.
Therefore, I tried to compare the character set. In pl/SQL, the character set is ZHS16GBK. There is no error. Therefore, we can compare the NLS_LANG under the oracle entry in the Registry to ZHS16GBK. There is no way. I don't know where to fix it. Think about whether the language set in the bios of the computer is incorrect. However, no exception was found after a circle was found in the bios. Or not. As a result, I found another computer to install the same environment, and then perform pl/SQL queries to find that there is no problem. This is why I am confused. There is no trick. At this time, a colleague said that the ZHS16GBK in the NLS_LANG in the registry should be changed to UTF8. So I changed ZHS16GBK to UTF8 and then performed the query. The result is normal. Haha, it succeeded.