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]

Re: Crypt datatype and datatype size

Raj wrote:
[color=blue]
> 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[/color]

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.