Question

我将sirectived 数据储存在 Mysql 中, 不知道要选择哪个字段类型?

系列数据产出的一个例子如下:

string(393) "a:3:{s:4:"name";s:22:"PACMAN-Appstap.net.rar";s:8:"trackers";a:6:{i:0;s:30:"http://tracker.ccc.de/announce";i:1;s:42:"http://tracker.openbittorrent.com/announce";i:2;s:36:"http://tracker.publicbt.com/announce";i:3;s:23:"udp://tracker.ccc.se:80";i:4;s:35:"udp://tracker.openbittorrent.com:80";i:5;s:29:"udp://tracker.publicbt.com:80";}s:5:"files";a:1:{s:22:"PACMAN-Appstap.net.rar";i:4147632;}}"

数据的字符串长度可大不相同,可高达约20,000个字符。

我理解我不想使用 TEXT 数据类型,因为这可能因其必须使用的字符组而损坏数据。

我被卡住了,因为使用 VARBINARY , BLOB , MEDIUMBLOB 等。

请允许我说,如果我使用 VARBINARY( 200000) (2,000) ,这是否意味着我可以安全地插入一个长度为 20000 的字符串,如果它已经结束,那么丢弃插入?

Answer 1

I agree with PLB in that you should use BLOB. The length attribute specifies how many bytes can be saved in this column. The main difference between BLOB and VARBINARY is that VARBINARY fills up unused space with padding, wheras with BLOB only the actual length of the data is reserved for one field.
But as PLB said, only use this if you absolutely must, because it slows down the whole DB in most cases. A better solution would be to store the files in your server s filesystem and save the file s path in the DB.

友情链接