Have the DBA’s converted the data to unicode? That would explain the additional space requirement..
Joe From: Kemes, Lisa Sent: Wednesday, April 04, 2012 2:50 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Large Character Fields even Larger? ** 287,351 characters.... Thanks! Lisa -------------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 04, 2012 2:44 PM To: [email protected] Subject: Re: Large Character Fields even Larger? ** What is the largest amount of data in that field? From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2012 1:02 PM To: [email protected] Subject: Re: Large Character Fields even Larger? ** Nevermind, when I increased it to 400,000 it now works. Why would it work in 7.1 p7 with 90000, but I have to increase it to 400,000 in 7.6.04 SP2? The data is basically the same. Thanks! Lisa -------------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2012 1:57 PM To: [email protected] Subject: Re: Large Character Fields even Larger? ** Sorry, I meant to say that I increased it to 200,000.... I just increased it again to 450,000 still same error message. Thanks! Lisa -------------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2012 1:27 PM To: [email protected] Subject: Large Character Fields even Larger? ** We upgraded from ARS 7.1 p7 to 7.6.04 SP2 and I'm found that one of my large character fields that I've set to 90000 (for example) is getting errors that the "Character String exceed maximum size allowed: 536870919" when I try to set it. It only happens to those records that do have quite a large amount of characters, but this never happened in 7.1 p7. I pushed it up to 20000 characters and I'm still getting the error. Looks like this is more on the DB side? Should I talk to my DBA? Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile [email protected] 100 Amp Drive Harrisburg, PA 17112 www.te.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
