MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Non-ASCII tablename not converted to lowercase in FK references
Posted by: Marko Mäkelä
Date: November 08, 2006 02:41PM

The probable reason why this happens to work in MySQL 5.1 is the "filename-safe" encoding, which uses only ASCII characters. InnoDB sees the file system name, not the raw table name.

MySQL 4.0 used latin1 for the data dictionary (table and column names), as far as I know. The system character set was changed to UTF-8 in version 4.1, but the InnoDB foreign key parser might still assume latin1 or ASCII in some places of the 4.1 or 5.0 trees. In 5.1, the lexical analysis part had to be rewritten in order to support the "filename-safe" encoding as well as the fall-back to the old encoding (the #mysql50# table name prefix).

Please file a bug report about this.

Marko Mäkelä
Innobase Oy/Oracle Corp.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Non-ASCII tablename not converted to lowercase in FK references
5024
David Balažic
November 07, 2006 08:57AM
Re: Non-ASCII tablename not converted to lowercase in FK references
2100
Marko Mäkelä
November 08, 2006 02:41PM
Re: Non-ASCII tablename not converted to lowercase in FK references
1848
Dave Page
July 07, 2008 06:05AM


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.