I’m having a problem updating unicode data (Turkish and Arabic text) into my Database using the DataProcessor.
I’m using row update in “one-by-one” mode, and for some of the rows of data there is no problem updating into the database, although an error is reported in the debugger server response:
<?xml version="1.0" encoding="utf-16"?>“XML error : A name was started with an invalid character.”
However for other rows the database is not updated and the error “Not an XML, probably incorrect content type specified ( must be text/xml ), or some text output was started before XML data” is reported.
I have used appropriate code for updating the data:
Response.ContentType = “text/xml”;
Response.ContentEncoding = System.Text.Encoding.Unicode;
and used UTF-16 in the XML header creation:
result.CreateXmlDeclaration(“1.0”, “utf-16”, null);
The status of the row is always reported as valid by the debugger and note I’m using DHTMLX 2.5 professional.
Have you any ideas as to where I’m going wrong?
DEBUG OUTPUT BELOW:
1.Successful update of database with unicode data (arabic and turkish text), but with an error reported - XML error : A name was started with an invalid character.
DataProcessor debug information:-
Server Response Details: XML error : A name was started with an invalid character.
Parameters:
gr_id=2
c0=13765
c1=2
c2=129
c3=%22%D8%B4%D8%A8%D8%AD%22%20%D8%A7%D9%84%D9%85%D8%A8%D8%AD%D9%88%D8%AD%20%D9%8A%D8%B7%D8%A7%D8%B1%D8%AF%20%D8%A5%D8%B3%D8%B1%D8%A7%D8%A6%D9%8A%D9%84
c4=‘Ghost’%20bo%C4%9Fuk%20%C4%B0srail%20%C3%A7%C4%B1km%C4%B1yor
c5=‘Ghost’%20bo%C4%9Fuvvk%20%C4%B0srail%20%C3%A7%C4%B1km%C4%B1yor%20xx.
c6=1
c7=MT
c8=%23009000
c9=1
c10=0
c11=False
c12=
c13=
c14=
c15=
c16=
c17=
c18=
c19=
c20=
!nativeeditor_status=row
- Unsuccessful update of database with unicode data (arabic and turkish text)
DataProcessor debug information:-
Server Response Details:
Not an XML, probably incorrect content type specified ( must be text/xml ), or some text output was started before XML data
Parameters:
gr_id=10
c0=13773
c1=10
c2=129
c3=%D9%88%D8%A3%D8%B6%D8%A7%D9%81%20%22%D9%84%D9%82%D8%AF%20%D8%AA%D9%88%D8%B5%D9%84%D9%86%D8%A7%20%D8%A5%D9%84%D9%89%20%D8%A7%D8%B3%D8%AA%D9%86%D8%AA%D8%A7%D8%AC%20%D8%A8%D8%A3%D9%86%20%D9%87%D8%B0%D8%A7%20%D8%A7%D9%84%D8%AA%D8%B2%D9%88%D9%8A%D8%B1%20%D9%82%D8%A7%D9%85%20%D8%A8%D9%87%20%D8%B9%D9%85%D9%84%D8%A7%D8%A1%20%D9%84%D8%AC%D9%87%D8%A7%D8%B2%20%D9%85%D8%AE%D8%A7%D8%A8%D8%B1%D8%A7%D8%AA.
c4='Biz%20doland%C4%B1r%C4%B1c%C4%B1l%C4%B1k%20istihbarat%20servisi%20ajanlar%C4%B1%20taraf%C4%B1ndan%20y%C3%BCr%C3%BCt%C3%BClen%20sonuca%20geldik.
c5='Biz%20doland%C4%B1r%C4%B1c%C4%B1l%C4%B1k%20istihbarat%20servisi%20ajanlar%C4%B1%20taraf%C4%B1ndan%20y%C3%BCr%C3%BCt%C3%BClen%20sonuca%20geldik.%20updated.
c6=1
c7=MT
c8=%23009000
c9=0
c10=0
c11=False
c12=
c13=
c14=
c15=
c16=
c17=
c18=
c19=
c20=
!nativeeditor_status=row