Special Character Issue

myukassign · Post by **myukassign** » Mon Aug 18, 2008 5:11 am

I am trying to transfer special character from Flat file A to Flat File B.

When I do a view data of sequential file, insted of showing the actul characters, it is showing "?" mark.

Can anyone help me?

The spcial character causing problem is "Đ Đ˝Đ"

ArndW · Post by **ArndW** » Mon Aug 18, 2008 6:30 am

The "view data" has always been an issue with multibyte data and the representations of special characters will mostly be incorrect. Use an OS tool that supports different character sets to view data like this.

myukassign · Post by **myukassign** » Mon Aug 18, 2008 7:18 am

Alrt!

I ran the job and verified the Falt file B. All the characters in Falt file A is not transferred to Falt file B. For some charactes it is showing "?" mark.

I am using NLS MAP as UTF-8 at source and target. But still m in trouble.

Can you please help me what can I do to resolve this issue?

ArndW · Post by **ArndW** » Mon Aug 18, 2008 8:54 am

That should not be possible. If you have a job with input file A and output file B, both declared as UTF-8 and declare the character columns (I think that the extended attribute is "unicode") the same in source and target then both file will be identical.

WoMaWil · Post by **WoMaWil** » Tue Aug 19, 2008 1:16 am

What tool do you take to look at your flat files?

myukassign · Post by **myukassign** » Tue Aug 19, 2008 2:42 am

Microsoft Notepad

ArndW · Post by **ArndW** » Tue Aug 19, 2008 3:26 am

Did you specify "unicode" in the extended attribute for the string fields?

WoMaWil · Post by **WoMaWil** » Tue Aug 19, 2008 7:15 am

In Microsoft Notepad you can choose the font and not all fonts support UNICODE

david_sol_llaven · Post by **david_sol_llaven** » Tue Aug 19, 2008 4:51 pm

myukassign wrote:Alrt!

I ran the job and verified the Falt file B. All the characters in Falt file A is not transferred to Falt file B. For some charactes it is showing "?" mark.

I am using NLS MAP as UTF-8 at source and target. But still m in trouble.

Can you please help me what can I do to resolve this issue?

Can you send me the files (or some part of them with the problem)?

Maybe the files are correct, but notepad doesn't display them.

david_sol_llaven - at - yahoo

myukassign · Post by **myukassign** » Wed Aug 20, 2008 4:03 am

Interesting somehow its working with UTF 8

I doono wht cahnge i made, but its working now.

I think might be some issues with the input junk data.

Anyway thanks a lot for all comments.

DSXchange

Special Character Issue

Special Character Issue

Let me see the files.