Hi,
When I execute the following script on SQL Server 2005 SP2 :
IF EXISTS (select * from sys.objects where name = 'TEXTEST2' and type_desc
= 'USER_TABLE')
BEGIN
DROP TABLE TEST.TEXTEST2
END
CREATE TABLE TEST.TEXTEST2
(
ARR XML
);
INSERT INTO TEST.TEXTEST2 (arr) VALUES ('<?xml version=''1.0''
encoding=''wind ows-1252''?><E0><E0 1 LT=''C''><![CDATA[L''échéancier &
env.ASP]]></E01><E02 LT=''C''><![CDATA["Tools" -->
"Terminkalender "]]></E02></E0>');
The result in the XML field (ARR) is :
<E0><E01 LT="C">L'échéan cier & env.ASP</E01><E02 LT="C">"Tools" -->
"Terminkalender "</E02></E0>
Why the CDATA section is gone ?
Thanks in advance.
When I execute the following script on SQL Server 2005 SP2 :
IF EXISTS (select * from sys.objects where name = 'TEXTEST2' and type_desc
= 'USER_TABLE')
BEGIN
DROP TABLE TEST.TEXTEST2
END
CREATE TABLE TEST.TEXTEST2
(
ARR XML
);
INSERT INTO TEST.TEXTEST2 (arr) VALUES ('<?xml version=''1.0''
encoding=''wind ows-1252''?><E0><E0 1 LT=''C''><![CDATA[L''échéancier &
env.ASP]]></E01><E02 LT=''C''><![CDATA["Tools" -->
"Terminkalender "]]></E02></E0>');
The result in the XML field (ARR) is :
<E0><E01 LT="C">L'échéan cier & env.ASP</E01><E02 LT="C">"Tools" -->
"Terminkalender "</E02></E0>
Why the CDATA section is gone ?
Thanks in advance.