Re: Smily Faces in stored procedures
Maybe this is the problem? (From
http://dev.mysql.com/doc/mysql/en/news-5-0-10.html ):
"The mysql.proc table was not being created properly with the proper utf8 character set and collation, causing server crashes for stored procedure operations if the server was using a multi-byte character set. To take advantage of the bug fix, mysql_fix_privilege_tables should be run to correct the structure of the mysql.proc table. (Bug #11365)
Note that it is necessary to run mysql_fix_privileges_tables when upgrading from a previous installation that contains the mysql.proc table (that is, from a previous 5.0 installation). Otherwise, creating stored procedures might not work."
pem, Senior Software Dev., MySQL AB
Subject
Views
Written By
Posted
2886
August 01, 2005 02:02PM
2014
August 02, 2005 03:44AM
1989
August 02, 2005 05:30AM
2220
August 02, 2005 05:42AM
Re: Smily Faces in stored procedures
2247
August 24, 2005 10:46AM
2093
August 25, 2005 11:49AM
1841
August 30, 2005 08:18AM
1562
September 05, 2005 05:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.