FTP PX Stage - UTF conversion

battaliou · Post by **battaliou** » Wed Sep 22, 2010 1:09 am

Have you defined your meta data as varchar unicode?

piyu · Post by **piyu** » Wed Sep 22, 2010 2:03 am

I tried both with and without unicode in Extended property for varchar.

Neither worked.

battaliou · Post by **battaliou** » Wed Sep 22, 2010 2:50 am

What happens when you "view data" ?

piyu · Post by **piyu** » Wed Sep 22, 2010 3:04 am

The file doesn't get FTPed. If you view the data in UNIX (after getting it manually), the characters are displayed fine in Vi editor but Datastage reads it as a ? that is, Datastage does let you "view" data but with a "?" for the unreadable character.

piyu · Post by **piyu** » Mon Sep 27, 2010 9:57 pm

Is this just an NLS problem?

jcthornton · Post by **jcthornton** » Sat Oct 09, 2010 5:37 pm

Would it be possible to switch your FTP mode to binary? It sounds like the problems are due to trying to send a non-ascii file as ascii.

chowdary_kish, you would be better served starting your own thread if a search doesn't give you the answer you need. Your problem is not identical to the original poster's.