Unable to read special characters

devidotcom · Post by **devidotcom** » Tue Mar 16, 2010 8:40 am

Any inputs for this post.

ArndW · Post by **ArndW** » Tue Mar 16, 2010 10:09 am

Choose your favorite UTF8 table from the internet and tell me what characters code points 0x81 and 0x8B are mapped to.

devidotcom · Post by **devidotcom** » Wed Mar 17, 2010 10:35 am

Thank you for the reply.

I searched online and found the following details:

Raw encoding: 0x81
UTF8 encoding: 0xC2,0x81
Description: (Undefined)

Raw encoding: 0x8B
UTF8 encoding: 0xC2,0x8B
Description: (Undefined)

How do I resolve this issue?

ArndW · Post by **ArndW** » Wed Mar 17, 2010 11:46 am

<sigh>

Since the characters are undefined in UTF-8 you cannot resolve the issue. Those two characters are not UTF-8 and that is why you are getting your error message.

Perhaps your source file is another character set. What glyphs are those characters supposed to represent? Could you have an ISO-8859-1 file?

devidotcom · Post by **devidotcom** » Thu Mar 18, 2010 12:10 pm

When i use the character set you mentioned I do not get the warnings. This ensure datastage is reading the records fine. But when the data gets loaded to the final oracle table I see some special chars loaded in place of these characters.
Am I missing something here?
Please advice.