Forum OpenACS Q&A: Re: Postgres 7.2.3 Data to Oracle 8.1.7

Posted by Andrew Piskorski on
Heiko, for Oracle, you want UTF8 character set encoding, not ASCII7 or anything else. Oracle asks you for "Character Set" and "National Character Set". I don't really know that that means, so I just pick UTF8 for both, and that seems to work ok.

Andrei, I would be very surprised if you'd be able to load a PostgreSQL dump into Oracle without major changes. Why else would OpenACS use completely separate Oracle and PostgreSQL versions of the *.sql package data model install files?