Page 1 of 1
Writing file in UTF-8 format
Posted: Fri Dec 10, 2010 5:08 am
by bicap
Hi,
I have target as sequention file stage, fixed width, now I need to wite data in UTF-8 format. so How can I do it.
Posted: Fri Dec 10, 2010 7:19 am
by Mike
I'd be surprised if you can ...
UTF-8 characters are 1 to 4 bytes in length. Unless you restrict yourself to a range of UTF-8 characters having the same length, fixed width is not going to work.
If you think your data is going to have all 1-byte UTF-8 characters, you can set the NLS code page to UTF-8 in your sequential file stage (assuming it is already configured as fixed width).
If your file ends up with different record sizes, then you likely have a character that was encoded with 2-4 bytes in UTF-8.
Mike