tags:

views:

35

answers:

1
Q: 

how is xml stored in database

Hi , 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 †......p.r.o.d.u.         
00000020:   63007400 ef000001 f801f7            †††††††††††††c.t........

Can anybody help me with this? Thanks!

+2  A: 

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.

TomTom  2010-03-08 15:58:46
Thanks for replying,i'm using SQL Server 2005.I had inserted an xml as <product/> in my database.(The hex dump of the record is mentioned above)the tag <product/> is stored as4ACDC06F: dfff01b0 04f00770 0072006f 00640075 †.......p.r.o.d.u 4ACDC07F: 00630074 00ef0000 01f801f7 ††††††††††.c.t........Can you help me reconstruct the tag ?Thanks
jude  2010-03-09 11:39:09
Nope, sorry. Why the heck (sorry) do you need that to start with? ;) I mean, I do SQL Server heavily for about 10 years now, and never had to deal with db storage internals.
TomTom  2010-03-09 11:42:44

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting