XML using PHP and MySQL

MySQL doesn't support XML data types like Microsoft SQL Server or PostgreSQL. Many times it is required to store multiple nodes of data into a single column, in the form of XML. In the MySQL, You have to store XML in CLOB (Character Large Object) data type .