... app, I am converting a varchar(max) type, passed to a stored procedure, to an XML data type in the stored proc. ...characters to legal equivalents? There are only two characters which need converting: & must be & and...illegal, just reserved. Real illegal characters are defined in the XML Spec, and they are mostly control characters which certainly shouldn't be in any ...

... SQL app, I am converting a varchar(max) type, passed to a stored procedure, to an XML data type in the stored proc. I've noticed ... contents of the varchar(max) string contains illegal XML characters (such as '&'), the conversion will fail. This doesn't surprise me, and I...some other method, that will convert all illegal XML characters to legal equivalents? Thanks - Amos.

... having 2 columns. Col A has type varbinary(max) Col B has type XML I'm storing XML Data in ColB and and a byte array representing the same XML data compressed in ColA. The goal ... of course to store only ColA data to save space. If I display ... try to decompress and cast the result as XML, I get a "XML parsing: line 1, character nnnnn, illegal xml character" error message. The process...

... having 2 columns. Col A has type varbinary(max) Col B has type XML I'm storing XML Data in ColB and...a byte array representing the same XML data compressed in ColA. The goal...of course to store only ColA data to save space. If I ...XML parsing: line 1, character nnnnn, illegal xml character" error message. The ...I tried storing and compressing the XML without encoding attribute, with other ...

... 0.00%% okay t/alvisXMLsplit....Illegal character in prototype for bytes...0/bytes.pm line 22. Illegal character in prototype for bytes...008 Cwd 0 3.2701 Data::Dumper 0 2.121_14 Digest...Path 0 2.04 File::Type 0 0.22 Getopt::Long...9711 Time::Simple 0 0.054 XML::LibXML 0 1.66...

...t/pod.............ok t/test............Illegal character in prototype for bytes...i386-freebsd-thread-multi/auto/Data/Dumper/Dumper.so: Undefined symbol...Have ------------------- ---- -------- CGI 0 3.29 Data::Dumper 0 2.121_14 Date...usr/local/src/CPAN/build/XML-NamespaceSupport-1.09-XRdDTx/blib...local/src/CPAN/build/MIME-Types-1.23-h8Jjwt/blib/arch...

...is a computer-generated report for Data-VString-0.000004 on perl 5..............ok t/002format..........Unicode character 0xfffe is illegal at t/002format.t...lib:/usr/local/src/CPAN/build/Data-Validate-Japanese-0.01001-mnVTiK/...:/usr/local/src/CPAN/build/Data-Validate-Japanese-0.01001-mnVTiK/...:/usr/local/src/CPAN/build/Data-XML-Variant-0.02-t9disY/.../local/src/CPAN/build/MIME-Types-1.23-uQSdXt/blib/arch:/...

... 0.00%% okay t/alvisXMLsplit....Illegal character in prototype for bytes...0/bytes.pm line 22. Illegal character in prototype for bytes...006 Cwd 0 3.25 Data::Dumper 0 2.121_14 Digest...Path 0 2.00_12 File::Type 0 0.22 Getopt::Long...9707 Time::Simple 0 0.052 XML::LibXML 0 1.65...

... 0.00%% okay t/alvisXMLsplit....Illegal character in prototype for bytes...0/bytes.pm line 22. Illegal character in prototype for bytes...007 Cwd 0 3.25_01 Data::Dumper 0 2.121_14 Digest...Path 0 2.02 File::Type 0 0.22 Getopt::Long...9708 Time::Simple 0 0.052 XML::LibXML 0 1.65...

....005 Cwd 0 3.25 Data::Dumper 0 2.121_13 Digest...Path 0 2.01 File::Type 0 0.22 Getopt::Long...9707 ! Time::Simple 0 n/a XML::LibXML 0 1.63...0.00%% okay t/alvisXMLsplit....Illegal character in prototype for bytes...5/bytes.pm line 22. Illegal character in prototype for bytes...