Home > Archive > PHP Programming > June 2004 > Crypt datatype and datatype size
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Crypt datatype and datatype size
|
|
|
| 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 2004-06-30, 3:57 pm |
| 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.
|
|
|
|
|