Difference between varchar2 (% N) and varchar2 (% N char)

1) varchar2 (N char) refers to the storage of a maximum of n characters, irrelevant to the number of bytes.

2) varchar2 (N byte) refers to the storage of up to n Bytes of length, and has nothing to do with the number of characters.

 

Varchar2 (50): 50 bytes. Based on the character set, 25 Chinese characters are stored in the same GBK format. utf8 stores 16 Chinese characters.
Varchar2 (50 char): 50 characters and 50 Chinese Characters

Difference between varchar2 (% N) and varchar2 (% N char)