Re: Export though Golden Gate - exceeds field length

2012-08-24 Thread Jose Manuel Huerta Guillén
It could also be an unicode issue. Depending how is codified, the length in bytes could be different that the number of characters. Jose Manuel Huerta http://theremedyforit.com/ On Fri, Aug 24, 2012 at 10:18 PM, Brittain, Mark wrote: > Golden Gate ___

Re: Export though Golden Gate - exceeds field length

2012-08-24 Thread Brittain, Mark
@ARSLIST.ORG Subject: Re: Export though Golden Gate - exceeds field length Mark, I don't believe Word will count characters correctly as it will try to fix up things like carriage returns and such. If I remember correctly you are using Oracle. To get a correct count in SQL do a SELECT LENGTH(C

Re: Export though Golden Gate - exceeds field length

2012-08-24 Thread Grooms, Frederick W
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Friday, August 24, 2012 1:48 PM To: arslist@ARSLIST.ORG Subject: Export though Golden Gate - exceeds field length ** Hi All, I have an situation where we are trying to export data fro

Export though Golden Gate - exceeds field length

2012-08-24 Thread Brittain, Mark
Hi All, I have an situation where we are trying to export data from the Remedy tables (e.g. T120) though Golden Gate and some records are being rejected because the incoming data exceeds the expected field/colmn size. If I take the character data from field and do a count in MS Word I get 992.