Please note: This e-mail is confidential and may also be privileged. Please notify us immediately if you are not the intended recipient. You should not copy it, forward it or use it for any purpose or disclose the contents to any person. -----------------------------------------------------------
if you were using Oracle you could store it in a CLOB which will store upto 4GB of Character data (if you you do use Oracle I would use the ODBC drivers and the native ones can be a bit funky with large columns in my experience). >>> [EMAIL PROTECTED] 07/10/02 04:50pm >>> The XML is just text. KEY!!! ... you may need to watch the size of the file. That is the main issue. Also, coldfusion has settings in the administrator that control the field size database structure will pass back in any one recordset. You will need to check that also. John Farrar > Is there something special you have to do to store an xml document in a database? I'm using the xml capabilities with CFMX to create my xml document object and wish to store it in my database. Do I need to convert it to something first? Do I use the xmlFormat function? Any insight would be appreciated. > > Thanks - Tom > > -----------------------+ > cf-xml mailing list > http://torchbox.com/xml/list.cfm > -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm ------------------------------------------------------------ Simmons & Simmons CityPoint One Ropemaker Street London EC2Y 9SS Tel +44 (0)20 7628 2020 Fax +44 (0)20 7628 2070 DX 12 London/Chancery Ln For details of our international offices please visit www.simmons-simmons.com A list of partners may be inspected at each office www.elexica.com is the award winning online legal resource powered by knowledge from Simmons & Simmons. -----------------------+ cf-xml mailing list http://torchbox.com/xml/list.cfm
