|
You may consider:
(a) using CLOBS if processing XML within a database is not significant; database is used as a storage and XML processing is delegated to application code;
(b) using stored procedures as it suggested in http://rpbouman.blogspot.com/2006/03/importing-xml-data-into-mysql-using.html.
MySQL team is considering to add XMLType support in future, see:
http://forums.mysql.com/read.php?44,155525,157883#msg-157883
Thank you.
|