DSXchange

Hi,

I am having the same issue with registered and trademark symbol as noted in this post. I am not being able to parse the xml file having those characters. Removing those characters will not help me as we need to store those values as well. I am using UTF-8 in the xml file as encoding scheme and nls_lang has value iso-8859-1.

Please help me on this.

Hi,
Any solution to the above mentioned problem? Please reply.

I did not mean that actually. Sorry if it means so.
But as I am stuck on this, I thought I would get reply from experts here in dsxchange.

I have nothing more to offer than that original thread. You are probably going to need to experiment with various escaped values, the encoding scheme, and/or perhaps NLS settings until you find the right combination.

Ernie

What have you tried so far? As Ernie notes, there is some advice in the linked thread that I split you from - curious if you have attempted anything from there yet.

In other words, let's get some specifics around your version of this error - what you are seeing, what you've tried so far, etc etc.

The problem of parsing the special characters are resolved. We have changed the actual xml file to replace the special characters with their hex values. In this way I could parse the xml files.

Now I am facing an issue to store the Trademark symbol in sql server database. I am not facing any issue with the registered/copyright symbol. When I am trying to store that in a sequential file we do not have any problem.
Again when we are trying to insert that trademark symbol by just writing a insert script, I did not have any issue.
So, this should not be a problem with datastage, as I could write that symbol in a file from datastage. Also, there should not be any issue with sql server either. Is there any issue with datastage and sql server combination?
Please let me know.

New problem = new post.

Please take the text that I italicized in your post and start a new post with it. Minus the italics of course.