Mysql AES encrypt an essay?
Posted: Wed Sep 30, 2015 7:06 pm
Greetings, members of the PHP Technorati. I come again with an issue concerning Encrypting a personal essay using Mysql AES encryption. If the essay is about 3000 characters long, How would I set it up in the database code to accommodate the size of the data being encrypted? here is the Table code:
Ok, so the Questions I have are:
How large(in characters) should the decrypt key be?
How will the size of the essay affect VARBINARY? Should it increase to accommodate the size of data being encrypted and by how much?
Please excuse my AES encryption ignorance and enlighten me.
Thanks in advance.
Batoe
Code: Select all
CREATE TABLE `my_2_cents` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT ,
`first_name` VARBINARY(100) NULL ,
`last_name` VARBINARY(100) NULL ,
`my_essay` VARBINARY(200???) NOT NULL ,
PRIMARY KEY (`id`))
ENGINE = MYSAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;
How large(in characters) should the decrypt key be?
How will the size of the essay affect VARBINARY? Should it increase to accommodate the size of data being encrypted and by how much?
Please excuse my AES encryption ignorance and enlighten me.
Thanks in advance.
Batoe