Page 1 of 1
Posted: Wed Sep 22, 2010 1:09 am
by battaliou
Have you defined your meta data as varchar unicode?
Posted: Wed Sep 22, 2010 2:03 am
by piyu
I tried both with and without unicode in Extended property for varchar.
Neither worked.
Posted: Wed Sep 22, 2010 2:50 am
by battaliou
What happens when you "view data" ?
Posted: Wed Sep 22, 2010 3:04 am
by piyu
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.
Posted: Mon Sep 27, 2010 9:57 pm
by piyu
Is this just an NLS problem?
Posted: Sat Oct 09, 2010 5:37 pm
by jcthornton
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.