DSXchange

Hello everyone,

I have a strange issue with removal of hard coded junk characters in a string.
Server #1: The job on SUN Solaris with NLS Not installed, using Oconv("<junk value>","MCP") removes the junk character and gives the desired result.

Server #2: However, importing the same job into another environment, HP-UX with NLS ENABLED, does not remove the junk character fully but replaces it with a "?". I tried using a convert function to remove this but does not help. I tried changing the NLS map options from UTF8 to ASCII to NONE but none helped. I am also trying to figure out why in this server #2, the "." is replaced by "?"?

example: junk string: ramprasad
result of server #1: ramprasad (after applying convert function for ".")
result of server #2: ram??prasad (even after applying convert function to remove "?")

Any help in this regard is highly appreciated.

Thanks for your time.

Regards,
ram

The "?" is not necessarily a junk character; it is more likely to be a perfectly normal character but one that can not be mapped using the character map that you currently have specified.

The solution to that is to determine how the characters in your data source are encoded, and to specify the appropriate NLS character map to process it without error.

Hi Ray,

Thanks for your quick response. However, i am not a premium member. Would it be possible for you to put it as a non-premium post? It will help me a lot.

Thanks.

Regards,
Ramprasad Ramani