Hello how do I change or alter the character set of a database for it to support nihongo characters
Oracle Database Character Set
3k views Asked by cedric At
2
There are 2 answers
4
On
You should be fine with any variety of UTF-8.
The character set is usually specified when creating the database. If you need to change it later, there is the ALTER DATABASE CHARACTER SET command, but that requires data migration:
To change the database character set, perform the following steps:
- Shut down the database, using either a SHUTDOWN IMMEDIATE or a SHUTDOWN NORMAL statement.
- Do a full backup of the database because the ALTER DATABASE CHARACTER SET statement cannot be rolled back.
- Complete the following statements:
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET new_character_set;
SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
STARTUP;
As you can see, you need to offline and convert the database.
And Unicode is your friend, use NVARCHAR or NTEXT.