UTF-8 encoding in field in recordset fails when saving into DOM object



Users have copied and pasted from an app into a textbox on a website, then saved the record. However when it came to viewing the record again the page threw an error.


It had some special characters, UTF-8 encoded.


I have added the following to the pages:



<% Response.CodePage = 65001 %>
<% Response.Charset="UTF-8" %>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />


When loading the page it retrieves the recordset fine but fails to load the recordset into a DOM object.



Set adoCn = Server.CreateObject("ADODB.Connection")
adoCn.Open Application("conn_string")
Set objCommand = Server.CreateObject("ADODB.Command")
Set objDOM = Server.CreateObject("Msxml2.DOMDocument.3.0")

objCommand.ActiveConnection = Application("conn_string")

spQry = "SP_QUERY"
objCommand.CommandText = spQry
objCommand.CommandType = adCmdStoredProc

Set objRs = objCommand.Execute

objRS.save objDOM, adPersistXML //Crashes here
Set objCommand = Nothing
objRS.Close
adoCn.Close
Set objRS = Nothing


This is the error Microsoft OLEDB Persistence Provider error 'c00ce508' Unknown error.


What else can I do to fix this?


No comments:

Post a Comment