Encrypt function in MySQL not working properly.

[Gen]

I'm using XammpLite and in my database when I try to use the encrypt on a column it has no affect and just wipes the data from that field making it blank.

Is this some sort of glitch or is not the encrypt function supported in the XammpLite package?

[Wiedmann]

or is not the encrypt function supported in the XammpLite package?

Ups, there is a manual:

If crypt() is not available on your system (as is the case with Windows), ENCRYPT() always returns NULL.

[Gen]

Hm, crypt() works in PHP though so I assumed encrypt would work but I guess that's not the case? Thanks for the answer.

[Wiedmann]

crypt() works in PHP though

The crypt() function in PHP is not the same as ENCRYPT() in MySQL or crypt(1) on *nix

[Gen]

I see, thanks for the fast answers.