Exporting Binary Database Results as Comma delimited CSV

[paulmadillo]

Hi.

I'm writing a function to export results from a database as a comma delimited CSV file.

The problem I'm having is that the table I'm exporting contains Blob data which can sometimes contain commas which would then escape to the next column of the CSV.

I tried str_replace()ing the commas but obviously this will just corrupt the binary data in the Blobs.

Does anyone know a way around this?

[Romeo]

Binary data does not fit well into a text string (as a CSV line finally is).

One way could be to encode the binary data with BASE64, so they get translated to 'text' and then can be handled more easily.

Kind regards,
R.

[paulmadillo]

Thanks for your quick reply Romeo.