Hi I am trying to insert a long XML string in a blob field in mysql.
So i am just using a normal insert statement is there an xml function i could use. This way I do have to keep escaping special characters in the xml string when inserting.
e.g i am using insert into table
values('test',' test','test','x mlstring')
Some rows go through but other records do not so does anyone know how i could insert an xml stirng which is everything from an xml file but in string format already.
So i am just using a normal insert statement is there an xml function i could use. This way I do have to keep escaping special characters in the xml string when inserting.
e.g i am using insert into table
values('test',' test','test','x mlstring')
Some rows go through but other records do not so does anyone know how i could insert an xml stirng which is everything from an xml file but in string format already.
Comment