Mysql – Storing ascii and binary data with in a single tab-delimited file


I've fallen into a situation where it would be advantageous to store both ascii and binary data within a tab-delimited file. My initial attempts were horrendous. Is this even worth pursuing? Any advice? I'll need to be able to cleanly parse the resulting tab-delimited file easily. Down stream, this data is going into a MySQLdb. And it would be nice to have the binary data stored within the db.

Best Solution

base64 encode your binary data. Maybe prefix it with base64: or something if that helps. Then it's just an ASCII file and you can easily parse it as such.

Related Question