Cast as XML issue

Hi,
Here is my problem:
I'm using one table 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 is of course to store only ColA data to save space.
If I display the content of ColB from a management studio query,
everything is perfectly displayed.
If I 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 is stuck on a string containing the char ...
The exact same string is perfectly displayed from ColB.
I tried storing and compressing the XML without encoding attribute,
with other encoding attribute, nothing helped.
Would someone have an advice?
Thanks,
Olivier
Can you write something more about your compression/decompression method?
Regards
Pawel Potasinski
[http://www.potasinski.pl]
Uzytkownik "oliviers" <olivier.sanzot@.gmail.com> napisal w wiadomosci
news:1185456328.444876.256200@.d55g2000hsg.googlegr oups.com...
Hi,
Here is my problem:
I'm using one table 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 is of course to store only ColA data to save space.
If I display the content of ColB from a management studio query,
everything is perfectly displayed.
If I 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 is stuck on a string containing the char ...
The exact same string is perfectly displayed from ColB.
I tried storing and compressing the XML without encoding attribute,
with other encoding attribute, nothing helped.
Would someone have an advice?
Thanks,
Olivier