PKP Bugzilla – Bug 1728
Reduce DB object names for compatibility with alternative DBMSs
Last modified: 2013-05-29 14:50:37 PDT
"The main stumbling block I'm coming across is Oracle's object name length
limit. MySQL's is 64 characters (I think), while Oracle's is 30. This includes
column, table, sequence, index and trigger names."
This would probably also require some modifications to the upgrade framework to
support DBMS-independent RENAMEs via ADOdb's data dictionary.
This will require a considerable rewrite of SQL queries to pull table names from variables.
Haven't heard of this in years -- suspect shaving bytes just isn't as popular as it used to be.