Open/Read UTF8 File - Allignement Issue

[Former Member]

I have a Microsoft Access file that is saved as UTF8 file. This file does contain both English and Chinese characters. Using FTP to move file to AS400 SAP directory. Viewed file in AL11 looks good, can see both English and Chinese characters.

ABAP pgm uses the following open command/options.

"Open dataset fname in text mode encoding default ignoring conversion errors"

No problem openning the file. However, when pgm issues the following read command only the fields containing english align correctly with structure.

"read dataset fname into structure."

I have tried setting the local language to '1' and then open the file. Did not change results, alignment continued to occur.

SAP Info:

OS = AS400

Version = 4.7

Unicode = Yes

[Former Member]

I have a Microsoft Access file that is saved as UTF8 file. This file does contain both English and Chinese characters. Using FTP to move file to AS400 SAP directory. Viewed file in AL11 looks good, can see both English and Chinese characters.

ABAP pgm uses the following open command/options.

"Open dataset fname in text mode encoding default ignoring conversion errors"

No problem openning the file. However, when pgm issues the following read command only the fields containing english align correctly with structure.

"read dataset fname into structure."

I have tried setting the local language to '1' and then open the file. Did not change results, alignment continued to occur.

SAP Info:

OS = AS400

Version = 4.7

Unicode = Yes

[naimesh_patel]

Try with this syntax to open your file

Open dataset fname in text mode encoding UTF8 ignoring conversion errors

Regards,

Naimesh Patel

[Former Member]

already tried that and it did not work.