Crypt datatype and datatype size

[Raj]

Hi all,

I am using crypt on PHP to encrypt a word and am in the process of
setting up the mysql databse to store the encypted word.

For the mysql database:

1) What datatype should I use? varchar, tinyblob, ... ?
2) what size do i need? varchar(10)/(20)/(30)?

Thanks in advance,

Raj

[Michael Austin]

Raj wrote:

Hi all,

I am using crypt on PHP to encrypt a word and am in the process of
setting up the mysql databse to store the encypted word.

For the mysql database:

1) What datatype should I use? varchar, tinyblob, ... ?
2) what size do i need? varchar(10)/(20)/(30)?

Thanks in advance,

Raj

how much data will be encrypted by crypt? what is the maximum number of
characters to be "crypt()'ed"? In doing some testing, using a 26 byte
key, a ten character input generates a 13 character output. YMMV.

Michael Austin.