Home > database >  Is there any possible MD5 checksum value and SHA256 check all match but different two files
Is there any possible MD5 checksum value and SHA256 check all match but different two files

Time:04-09

Is there any possible MD5 checksum value and SHA256 check all match but different two files, if you have, then both at the same time, the probability of collision is how old? Recently I want to make a joint indexing, so that the rapid retrieval network backup system inside the existence of a file hash value matching,

Below is I'm in the design of table
 
The create table tb_file
(
File_id bigint not null PRIMARY KEY AUTO_INCREMENT,
File_name text (255) not null,
File_size bigint not null,
File_type bigint not null,
File_status int the not null,
File_upload_time text not null,
File_hash_md5 text (128),
File_hash_sha256 text (256),
The index index_file_name (file_name (250)),
The index index_file_status (file_status),
The index index_file_hash_md5 (file_hash_md5 (128)),
The index index_file_hash_sha256 (file_hash_sha256 (250)),
The unique index_file_hash_md5_sha256 (file_hash_md5 (128), file_hash_sha256 (122))
) AUTO_INCREMENT=10000 ENGINE=InnoDB CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=Dynamic;
  • Related