MySQL Forums
Forum List  »  Stored Procedures

Re: Stored routine string variables in 5.0.18: No collation?
Posted by: Per-Erik Martin
Date: January 10, 2006 04:39AM

The reason is that COLLATE was not allowed for local variables in the SQL:1999 standard.
However, this was changed in the the SQL:2003 standard, where COLLATE is part of the specification of character string variables.
(It's possible that this was a mistake in the earlier version, but there's no way for us to know.)

So the issue is known and reported as a feature request.

pem, Senior Software Dev., MySQL AB

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Stored routine string variables in 5.0.18: No collation?
1381
January 10, 2006 04:39AM


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.