Home > database >  Why I use PLSQL query 6 bytes is a Chinese??????
Why I use PLSQL query 6 bytes is a Chinese??????

Time:10-18

CodePudding user response:

Try other client do you use? Feeling with what the mess of characters, and dump (' you ') see, really is 6 bytes,

CodePudding user response:

Solved, originally is my this environment variable configuration wrong configuration become
NLS_LANG SIMPLIFIED=CHINESE_CHINA. ZHS16GBK
The correct should be:
NLS_LANG=SIMPLIFIED CHINESE_CHINA. ZHS16GBK

CodePudding user response:

We'll know is coding issues a look at this

CodePudding user response:

Suggest take baidu about the LENGTH and the difference between LENGTHB
https://jingyan.baidu.com/article/f3ad7d0f1b947109c2345b5e.html

CodePudding user response:

refer to the second floor weixin_44904947 response:
solved, originally is my this environment variable configuration wrong configuration become
NLS_LANG SIMPLIFIED=CHINESE_CHINA. ZHS16GBK
The correct should be:
NLS_LANG=SIMPLIFIED CHINESE_CHINA. ZHS16GBK


If simply NLS_LANG configuration errors, when you connect to the database will be an error,

CodePudding user response:

reference 5 floor minsic78 reply:
Quote: refer to the second floor weixin_44904947 response:

Solved, originally is my this environment variable configuration wrong configuration become
NLS_LANG SIMPLIFIED=CHINESE_CHINA. ZHS16GBK
The correct should be:
NLS_LANG=SIMPLIFIED CHINESE_CHINA. ZHS16GBK


If simply NLS_LANG configuration errors, when you connect to the database will be an error,

Key magical place right here, database connection thoroughly, is not an error, the configuration character encoding configuration, estimated to connect to the database didn't influence,
  • Related