Hi, I'm trying to save some data taken from a ISO-8859-1 encoded page into a SQL SERVER 2005. The problem I have is that when I retrieve the information and put it in a XML there are characters missing. I'm using the URLEncoder.encode method to escape the "bad" characters from the html before saving the data, and I've tried several combination of charsets as a parameter(UTF-8 and ISO-8859-1). The XML can be iso or utf-8, it doesn't mather. I've been working on this for several hours but I can't seem to find the solution. Any ideas will be appreciated.
Thanks in advance.