patternMinor
oracle tablespace character set
Viewed 0 times
oracletablespacesetcharacter
Problem
I'm working with Oracle databases from 10g-r1 to 11g-r2. They are set as ISO-8859-15 (WE8ISO8859P15) character set.
I need to create a tablespace set as UTF-8 (AL32UTF8) character set inside these databases. Is it possible? What is the correct syntax?
I need to create a tablespace set as UTF-8 (AL32UTF8) character set inside these databases. Is it possible? What is the correct syntax?
Solution
The character set of an Oracle database is set at the database level, not tablespace level.
You have 3 options:
NVARCHAR2()/NCHAR() datatypes instead of VARCHAR2() (documented at the same link as above)
You have 3 options:
- Recreate the database with the correct character set
- Convert the database to AL32UTF8. Documentation link
- Change the databases National Character Set to AL32UTF8 & change your application to use
NVARCHAR2()/NCHAR() datatypes instead of VARCHAR2() (documented at the same link as above)
Context
StackExchange Database Administrators Q#16006, answer score: 5
Revisions (0)
No revisions yet.