Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Convert special characters to readable ones

 
Pavan Kashyap
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am getting an error, which says The character '' is an invalid character. Actually i am trying to create an xml from the data that comes from the database. In that data this character is there and it is not accepting this.

The data comes from a different language. I tried using UTF-8 and ISO-8859-1 for the encoding, but didnt get resolved.

I need to convert this character so that xml can handle that.

Please let me know for any solution.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the encoding that the database uses and what is the encoding that the target XML file should use ?
 
Pavan Kashyap
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am not sure of the encoding on the database side, from the xml side i am currently using "UTF-8" for encoding
 
Paul Clapham
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It looks like your character is U+0008, or hex-08 if you like. This character is not permitted in any XML document, so what you have there is not a well-formed XML document. Encoding doesn't have anything to do with it.

You are producing this document from a database? Then you will have to filter out invalid characters before writing the others to the document. And you will need to know which characters are permitted and which ones aren't. The XML Recommendation tells you that; section 2.2 is the part you should particularly read.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic