Character Set in Oracle

If only English software is used, character sets are rarely considered. However, if other languages are used, character sets must be considered. Otherwise, a lot of garbled characters may occur accidentally.

 

Many other software also has character sets, such as Windows Office software, but office uses the character set that comes with windows. If a character set is not installed on windows, the office software cannot display the content normally. The character set of Oracle is built-in. That is to say, even if the operating system does not have a character set, it can be displayed normally in Oracle. This ensures the same performance of Oracle in each system platform.

 

The main character set is described here.

1. ASCII. I'm afraid this character set is not supported by the operating system. It will be learned from the computer. This is a single byte, that is, a character is a byte.
2. Al16utf16 is a 2-byte UNICODE character set. That is to say, all characters occupy 2 bytes. This is the only 2-Byte Character Set in Oracle10g. Therefore, if you want to use a 2-Byte Character Set, select it.
3. Utf8. the character set may contain 1 to 4 bytes and has different lengths.
4. Ja16sjis, a variable-length character set, is generally used in Japanese databases.
5. Al32utf8 is also a Unicode character set, but the character length is variable.

In short, when using the database, you must be clear about the character set used by the database so that you can accurately calculate the space occupied by some data.