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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.