how is xml stored in database
I have a table with one of the column being of type xml I enetered record as insert into table_1 values(1,'') i opened the mdf file in hex i found the "<>" missing. This is how it looks.
00000000: 30000800 01000000 02000001 002b00df †0............+..
00000010: ff01b004 f0077000 72006f00 64007500 †......开发者_StackOverflow社区p.r.o.d.u.
00000020: 63007400 ef000001 f801f7 †††††††††††††c.t........
Can anybody help me with this? Thanks!
mdf = SQL Server.
Which version? What is the field like?
XML field - well... ...it is stored in form of data (not documented), not as text. This is mosstly done to support the advanced query functionality. Not ethat this means storing XML and retrieving it may CHANGE THE STRING - as surplus spaces are removed. This eliminates... the validity of signed XML elements (if you use signatures in XML).
Basically, the XML structure is parsed and the data stored in a separate database structure.
精彩评论