Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

The character set of an Oracle database is set at the database level, not tablespace level.

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)
share|improve this answer

That is not possible.

The character set is defined for the whole instance, you cannot change it for a tablespace.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.