On 3/8/2012 1:07 PM, David Horwitz wrote: > aha that explains why I didn't see it - out of habit I set my default > table type to INODB. > > Sounds like we have either a ddl tweak needed or a documentation change ...
Forgive my ignorance (you'd think the guy assigned to that ticket would know more about this eh?), but changing the table type would have fixed the key size limits? I've fixed the issue in both code and ddl so I'm leery of changing it again for 1.3, but we could consider this for 1.4 assuming the ddl generation code understands that it needs to append the table type to the creation statements. G > D > > On 03/08/2012 05:17 PM, Erik Nell wrote: >> >> Dear Opencast-Community, >> >> >> >> we have possibly a solution for the problem with ddl-script/UTF-8 >> SQL-import - using the latest mysql5.sql (see also >> http://opencast.jira.com/browse/MH-8506) >> >> You only have to change the standard engine in MySQL from MyISAM to >> InnoDB for each “CREATE TABLE” statement in the mysql5.sql-File – it >> works fine! (the crucial tip comes from Sven Strickroth, Department of >> Informatics TU Clausthal ) >> >> >> >> CREATE TABLE … ( >> … >> ) engine = INNODB; >> >> >> >> Sincerely >> >> Erik Nell >> >> >> >> ----------snip-8<----------snap-8<--------- >> >> >> >> Erik Nell >> >> Fachinformatiker für Systemintegration >> >> >> >> TU Clausthal >> >> Rechenzentrum >> >> Erzstraße 51 >> >> 38678 Clausthal-Zellerfeld >> >> >> >> phone: +49-5323-72-2791 >> >> mobil: +49-5323-72-912791 >> >> fax: +49-5323-72-3536 >> >> >> >> e-mail: [email protected] <mailto:[email protected]> >> >> utl: http://rz.tu-clausthal.de <http://rz.tu-clausthal.de/> >> >> >> >> >> >> _______________________________________________ >> Community mailing list >> [email protected] >> http://lists.opencastproject.org/mailman/listinfo/community >> >> >> To unsubscribe please email >> [email protected] >> _______________________________________________ > > > > _______________________________________________ > Community mailing list > [email protected] > http://lists.opencastproject.org/mailman/listinfo/community > > > To unsubscribe please email > [email protected] > _______________________________________________ _______________________________________________ Community mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/community To unsubscribe please email [email protected] _______________________________________________
