At 11:41 -0400 10/11/04, Jerry Swanson wrote:
I create table and used password
// CHAR(15)
select password('123456');
+--------------------+
| password('123456') |
+--------------------+
| 565491d704013245 |
+--------------------+
//INT(10)
+-----------------+
| password |
+-----------------+
| 565491d70401324 |
When I used char(15) the data was not complete.
What data type I should use for password function?
Actually, you should use a different function than PASSWORD(), which
should be used only in connection with account information in the
grant tables in the mysql database. SHA() or MD5() some possibilities.
See this section in the manual:
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]