How to determine the column length in different database character set and length semantics? For example, you need to define a VARCHAR2 column that can store up to 5 Chinese characters together with 5 English characters.
Database Character Set | |||
Length Semantics | Single byte | Multiple byte | |
BYTE | 10 BYTE | 5*3+5*1=20 BYTE | |
CHAR | 10 CHAR | 10 CHAR | |
Posts
Post a Comment