Issue with reading the fixed width multi-byte characters

senthilnaga · Post by **senthilnaga** » Fri Mar 04, 2016 4:51 am

The input file is a fixed width '.dat' file and we read the file using a 'Sequential file' stage and we segregate the columns based on the position as the input file is fixed width. The issue arises when we started receiving the multi-byte characters in name and address field.
Since the multi-byte characters occupy more than one character, sequential file stage reads it wrongly. I even changed the NLS setting to UTF-8, but it didn't work. Please advise how to resolve this issue.

prasson_ibm · Post by **prasson_ibm** » Fri Mar 04, 2016 5:13 am

Hi,

Read it as Unicode character.

chulett · Post by **chulett** » Fri Mar 04, 2016 8:03 am

And just post your issue once in one forum, please. No need to spread it around.