在CSV文件中传输二进制数据(图像等) [英] Transfer binary data (image etc) in a CSV file

问题描述

除了存储为字符串，数字等的其他一些元数据信息外，我还有一些二进制数据要传输.我拥有的二进制数据是作为blob列存储在数据库中的图像文件，我想将blob列包含在数据库中. csv文件并将 csv 文件存储在文件系统或sftp服务器中，我想它的存储位置无关紧要.

I have some binary data to transfer in addition to some other metadata information stored as string, number etc. The binary data I have is image files stored as a blob column in the database, I want to include the blob column in the csv file and store the csv file in filesystem or sftp server, I guess it does not matter where it is stored.

如何将二进制数据存储为 csv 文件中的另一列?以这种方式传输二进制数据是一个好习惯吗?

How can the binary data be stored as another column in the csv file? Is this a good practice to transfer the binary data this way?

推荐答案

Base64

通常(也是正确的)方法是在 Base64 中对二进制数据进行编码.这样会将数据放大4:3.

Base64

The usual (and proper) way is to encode the binary data in Base64. This will make the data larger by a factor 4:3.

虽然 CSV 文件通常被认为是文本文件，但您可以将原始二进制数据写入文件.

While CSV files are generally considered to be text files, you could write raw binary data to the file.

然后应将该数据用双引号引起来，并且数据中所有现有的双引号都必须用另一个双引号进行转义.引用这些字段还可以处理二进制数据中的任何换行符，但读者必须对此予以支持.如果读者知道它正在读取二进制数据(即，如果您自己提供读取器)，则其中也可能存在空字节，这不成问题.

That data should then be enclosed in duoble quotes, and all existing double quotes inside the data have to be escaped with another double quote. Quoting the fields will also take care of any newlines in the binary data, but the reader has to support that. There could also be null bytes inside which should not be a problem if the reader knows it's reading binary data (i.e. if you provide the reader yourself).

但是，如果您的数据必须采用某种unicode格式，则可能会出现问题.

Problems could arise however if your data has to be in some unicode form..

因此，通常将原始二进制数据写入csv文件不是一个好习惯，最好使用base64编码.

So, in general it is not good practice to write raw binary data to a csv file, it's better to use base64 encoding.

这篇关于在CSV文件中传输二进制数据(图像等)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！