Mysql AES encrypt an essay?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
cap2cap10
Forum Contributor
Posts: 158
Joined: Mon Apr 14, 2008 11:06 pm

Mysql AES encrypt an essay?

Post by cap2cap10 »

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:

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;

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
Post Reply