Blob or MediumText?

[Vincent Senese]

I need to send a large amount of text charectors to a mysql database via a stored routine/procedure. The text length is on average 400000 charectors long.

Should I send this to the procedure via just passing it as a mediumtext datatype, or should I serialize it and send it as a blob (I do not know if it is even possible to use a blob datatype with a procedure.)

Once in the procedure I need to work with the file in readable format so if I use a blob method I would need to convert it back to the readable file.

What is the sugested method, I think mediumtext makes the most sense, but if not, what should I do. Also if a BLOB is the correct choice, please show me a sample of how I would convet the string to a blob the unconvert in mysql.

Thanks