To tylko jedna z 2 stron tej notatki. Zaloguj się aby zobaczyć ten dokument.
Zobacz
całą notatkę
Character Sets Use this tab to define the character sets used by your database.
Character sets are the encoding schemes used to display characters on your computer
screen. The character set determines what languages can be represented in the
database.
Oracle recommends using Unicode (AL32UTF8) as the database character set.
AL32UTF8 is Oracle's name for the UTF-8 encoding of the Unicode standard. The
Unicode standard is the universal character set that supports most of the currently
spoken languages of the world. The use of the Unicode standard is indispensable for
any multilingual technology, including database processing.
After a database is created and accumulates production data, changing the database
character set is a time consuming and complex project. Therefore, it is very important
to select the right character set at installation time. Even if the database does not
currently store multilingual data but is expected to store multilingual data within a
few years, the choice of AL32UTF8 for the database character set is usually the only
good decision.
If you create a CDB, consider that the character set you select determines which other
databases you can later plug into the CDB. Only databases with a compatible database
character set can be plugged into the CDB.
The default character set used by Oracle Universal Installer (OUI) and Database
Configuration Assistant (DBCA) for the UNIX, Linux, and Microsoft Windows
platforms is not AL32UTF8, but a Microsoft Windows character set known as an ANSI
code page. The particular character set is selected based on the current language
(locale) of the operating system session that started OUI or DBCA. If the language is
American English or a Western European language, then the default character set is
WE8MSWIN1252. Each Microsoft Windows ANSI Code Page can store data from only
one language or a limited group of languages, such as only Western European, or only
Eastern European, or only Japanese.
A Microsoft Windows character set is the default even for databases created on UNIX
and Linux platforms because Microsoft Windows is the prevalent platform for client
workstations. Oracle Client libraries automatically perform the necessary character set
... zobacz całą notatkę
Komentarze użytkowników (0)