Just saw your earlier reply. If going from US7ASCII to WE8MSWIN1252, everything should convert properly since US7ASCII is a strict subset of WE8MSWIN1252. This does, however, require a conversion of the data.
I suggest going to AL32UTF8 instead of WE8MSWIN1252, even if you don't plan on using Unicode characters at this time, if you can talk your DBA into it. You will save yourself a big headache later if you ever want to support Unicode. Do keep in mind that with the deprecation of the user tool all your users will have a Unicode capable client. Check this article for a view on the conversion: http://gavinsoorma.com/2011/07/changing-the-database-characterset-from-us7ascii-to-we8mswin1252/ The data has to be converted to change character sets. I'm not sure what happens if you just change the oracle configuration and mount data files that contain a different character set. I would imagine that some characters are going to be garbled. On Wed, Mar 21, 2012 at 2:24 PM, Axton <[email protected]> wrote: > Character set conversions can be tricky business. You have to make sure > you decode/re-encode the data properly. This may not be all that possible > with some things. What are your source and target character sets? > > Axton Grams > > > On Wed, Mar 21, 2012 at 11:05 AM, Bray, Joshua <[email protected]>wrote: > >> ** >> >> Good Morning,**** >> >> ** ** >> >> We are trying to upgrade from Oracle 10g to 11g and are getting errors >> when we restart the AR Server (we are on 7.5 patch 6, on windows 2003). The >> errors are “390600 : Error in definition for an active link (ARERR 399)”, >> on every active link. We are getting these because we had to change the >> character set. Oracle 11g is no longer compatible with what we were using. >> **** >> >> ** ** >> >> We are completely customized, no out of the box stuff. Has anyone else >> done this, with a similar configuration? BMC has a suggestion, but it’s a >> bit painful and wondering if anyone else has a better way.**** >> >> ** ** >> >> Thanks,**** >> >> Josh Bray**** >> >> Turner Broadcasting System, INC**** >> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
