Hi everyone
    I am teaching myself PHP & MYSQL programming with the book, "Beginning PHP 4". In chapter 11 we create a database and two tables then enter data into the tables using the command line. I am using Windows 2000 PHP 5.2.0 and MYSQL 5.0.27. The problem I am having is MYSQL will not accept data entered into the user table in the userpassword column using the password('12345') function. An error is returned that the data is too long to fit in the column even though the column is VARCHAR(20). The column will accept up to 20 characters without the password() function, but not even ONE character sent to MYSQL password() function. I searched MYSQL home page and I seem to be the only one with this problem. Even searching GOOGLE only shows up problems with encoding foreign characters. Thanks.

everetts

I have stumbled on the solution to my problem. The column width to use with the password function has to be large. I started with 128 characters, and then I am going to go smaller until I get an error again

Everetts,
I believe 40 characters on password function is the minimum for MySQL started from version 4.1 and updward. I remembered vividly when I upgraded from 4.0 version to 4.1
Hope this helps.
John