MySQL Forums
Forum List  »  Stored Procedures

Re: Smily Faces in stored procedures
Posted by: Per-Erik Martin
Date: August 24, 2005 10:46AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2886
August 01, 2005 02:02PM
1989
August 02, 2005 05:30AM
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.