Problem MYSQL password() Function
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.