Bug #6613 Stored procedures named ÿ are hard to use
Submitted: 14 Nov 2004 20:07 Modified: 15 Nov 2004 18:52
Reporter: Peter Gulutzan Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: CPU Architecture:Any

[14 Nov 2004 20:07] Peter Gulutzan 
Description:
It's often bad to use ÿ (which in ISO 8859-1 is code point 255) for a name, and the MySQL 
Reference Manual in fact says: "no identifier can contain ASCII 0 or a byte with a value of 
255". But I can create a function named ÿ. The trouble is, I can't find it again after doing so. 
 

How to repeat:
mysql> create function ÿ () returns int return 5; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> select ÿ(); 
ERROR 1305 (42000): FUNCTION db5.ÿ does not exist 
 
mysql> drop function ÿ; 
ERROR 1305 (42000): FUNCTION db5.ÿ does not exist 
 
mysql> set @x = ÿ (); 
ERROR 1305 (42000): FUNCTION db5.ÿ does not exist
[15 Nov 2004 10:46] Marko Mäkelä 
Peter,
ÿ is 0xff in ISO 8859-1, but it is 0xc3 0xbf in UTF-8. 0xff doesn't occur in any UTF-8 encoding.
[15 Nov 2004 18:52] Peter Gulutzan 
Sorry, I see that I already had a note about ÿ in BUG#3349.