Truncation of data for varchar field while using ODBC stage.

ujala · Post by **ujala** » Mon Jul 23, 2012 10:45 pm

Yes, integer values come across the ODBC interface correctly.

As mentioned earlier i am facing problem only with varchar fields.

ArndW · Post by **ArndW** » Tue Jul 24, 2012 12:32 am

That is quite strange behaviour indeed. If you write to your table then capture the display the value to a file for a known string, i.e. "ABC" then do an od -x on just the first character shown, what is the value? We need to know the expected value of the first character "A" and the resulting representation in order to guess what might be happening.

venkateshrupineni · Post by **venkateshrupineni** » Tue Jul 24, 2012 12:51 am

i may thought it may be the issue with Length of column or NLS try to change the length and check it once...

other try to use cast function and increase your length of your truncate clumn at the source level and passed that changed value to further stages..try this ...

ujala · Post by **ujala** » Tue Jul 24, 2012 12:52 am

sorry but i didnot get it.

Can u specify in detail

ujala · Post by **ujala** » Tue Jul 24, 2012 11:20 pm

Ran the job Changing the length and NLS and also used cast function but same result..

I am getting only the first character in the output.

ArndW · Post by **ArndW** » Wed Jul 25, 2012 12:49 am

You still aren't answering the important questions. Again - what is the first character of the string supposed to be and what is the ascii code of the first character coming out.

ujala · Post by **ujala** » Mon Aug 13, 2012 7:16 am

found a work around - if i use ODBC stage instead of ODBC connector, it works fine

chulett · Post by **chulett** » Mon Aug 13, 2012 7:20 am

Then it seems to me that you should report this to your official support provider.