Axton, Thanks for the assist. I need to work through some thoughts and come up with a conversion plan. Luckily there are few forms where we actually use the local language view so we may simply delete those views. Also we do not need to keep some of the data like in the AR System Email messages forms. 99% of our forms that display in a local language use View forms and data to display the text in the local language.
Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton Sent: Thursday, January 28, 2010 2:56 PM To: [email protected] Subject: Re: 7.5 Installation Problems (of course!) ** UTF8 character set uses CESU-8 code points, which are not compatible with the client character set AMERICAN_AMERICA.AL32UTF8 but are compatible with the client character set AMERICAN_AMERICA.WE8MSWIN1252. Read here: http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410550 http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14225/ch11charsetmig.htm#CEGCGEAF <http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410550> I believe there is invalid data in the db that will have to be converted/cleaned up if you want to change the client localization settings and expect it to work. This means moving all the 8-bit characters (CESU-8, or whatever else there are) to the proper UTF-8 code point so that a client expecting that data can understand it. -- Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Thu, Jan 28, 2010 at 12:15 PM, Shellman, David <[email protected]<mailto:[email protected]>> wrote: ** Axton, Here is what I got back from our DBA. "The data in the database is in utf8 characterset. The database would not allow it to be stored other than that. The application would have a failure on the storing of invalid characters which would show up on the (application server). I can run the csscan though. The csscan is used when you want to convert your characterset and we do not want to do that." Dave _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
