There's a whole spread of stuff on MetalLink about changing character sets. There is even a utility program called 'csscan' that scans the DB to find potential trouble spots.
In short, though, if this DB only has 7-bit ASCII characters in in, then a switch to UTF-8 will have no immediate effect. Cheers, Mike -----Original Message----- Sent: Wednesday, November 19, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Anyone change character sets recently? I've got a cust that wants to take a small database from US7ASCII to UTF8 I believe it was. It sounds like they have all the steps down pat and are pretty much ready to go, but are there any "gotchas" they may have missed? Will this affect the RMAN backups they get nightly? I've told them to do a cold file backup first, then try on test, and if all is cool they can proceed... 20 years working with Oracle and this is a first time for me. Web interface on this note, so I hope it comes out okay... -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
