Re: save XML into database
* Michael Rys <mrys@m...> [2005-10-28 23:22]: > Well, the problem is that often if the XML data comes from another > provider, you do not know what code page you need to use without looking > at the data (which you want to avoid). And storing different documents > of different encodings is problematic at best if you are using the > notion of a code page and a string type. If you however use a binary > type then the encoding of the XML is preserved and you do not get into a > code-page issue and an XML parser will be happy. Obviously similar > things can be said about using an XML datatype (which most likely will > use either UTF-8 or UTF-16 as internal encoding). > > Using different XML Schemas is less of a problem with concepts such as > the XML Schema collections that are currently supported in SQL Server > 2005 and are also part of the upcoming SQL standard... Has anyone suggested saving to the file system, and just using an SQL database as index? It makes it easier to manipulate the collection with XSLT. It's what I do. Just wondering. -- Alan Gutierrez - alan@e... - http://engrm.com/blogometer/
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format