Unfortunately, our csscan is coming up with different errors each time we run it. It's not consistent at all. What we want to do is find the records that are not compatible, move them to dev and convert them as a "test" to see what happens. But with 2500+ records that are constantly changing on the results, it's been very hard for us to pinpoint which records are really the problem.
Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Thursday, January 28, 2010 5:17 PM To: arslist@ARSLIST.ORG Subject: Re: 7.5 Installation Problems (of course!) ** You're welcome. I am going through the same thing right now, so it's all fresh in my mind. 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 3:41 PM, Shellman, David <dave.shell...@tycoelectronics.com<mailto:dave.shell...@tycoelectronics.com>> wrote: ** 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Axton Sent: Thursday, January 28, 2010 2:56 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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 <dave.shell...@tycoelectronics.com<mailto:dave.shell...@tycoelectronics.com>> 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: rmisoluti...@verizon.net<mailto:rmisoluti...@verizon.net> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net<mailto:rmisoluti...@verizon.net> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"