MySQL Forums
Forum List  »  Stored Procedures

Re: Problems using LOOP..END LOOP, label and LEAVE
Posted by: Roland Bouman
Date: July 01, 2005 04:39PM

Hi! It seems there actually is light at the end of the tunnel. see bug# 7088. setting the character set to latin1 before creating, calling or dropping the procedure solves the problem. My (server) default was -and is - utf8.
Bizarre results though, try creating a procedure while setting the character set to latin1, compile a proc with labeled loops, switch to utf8, then try to's all quite puzzling when you're not aware it's just you're charset bugging you...

Thanks a lot everyone for putting time and effort into this, I think it ends here for now and really when it would get solved in some future release. But at least, some workaround is known

Options: ReplyQuote

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.