RE: Extended Characters

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Tue, 13 Apr 2004 17:16:31 -0600
Message-ID: <87E9F113CEF1D211A4C30090273018741BBBAD@ddbcinc.ddbc.local>

Mladen,

"The database can be converted to UTF-8 (AL32UTF8) which works fine with the database, but I don't know whether the Cold ConFusion can actually handle UTF-8 characters. If your database is 9.2, your DBA will be able to do that with an "ALTER DATABASE" command, which will take forever to complete, but if it is an oracle8i, the full export/import will be needed."

Are you sure about that ALTER DATABASE CHARACTER SET statement? According to the latest 9.2 Globalization Guide http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch10 .htm#1009904, the new character set needs to be a strict binary superset of the current database character set. Since AL32UTF8 is not a strict binary superset of WE8DEC, I believe a full export & import would be necessary.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Apr 13 2004 - 18:09:55 CDT