In oracle, how to determine a field, such as name, whether meet the GBK code

CodePudding user response:

Meet what GBK code, to judge whether Chinese characters?

CodePudding user response:

reference 1st floor liuzhe_521 response:

meet what GBK code, to judge whether Chinese characters?

I don't know if Chinese characters are all included in the GBK code, is strange character name in this field, the data to quality inspection found that there are dozens of don't meet the GBK code

CodePudding user response:

That you are about to modify the character set? Choose a larger character set

CodePudding user response:

Check the GBK character range, with regular match again;

CodePudding user response:

Don't understand, help,,, don't know much about what GBK, it's a character set? How to store? Hexadecimal? Whether to have the corresponding Chinese characters bar?
If it is in Chinese to match a pure character, how GBK a man for me?