I have the exact same issue. Would very much like for the MySQL compatibility mode to accept these.
Stig On Thursday, 6 December 2012 03:11:33 UTC, JetForMe wrote: > > Hi. My MqSQL creation SQL looks like this: > > create table Foo (<stuff>) Engine=InnoDB charset=UTF8; > > Even with MySQL compatibility on (my datasource URL is > "jdbc:h2:mem:gcs;MODE=MySQL;INIT=RUNSCRIPT > FROM 'src/sql/schema.sql'"), H2 balks at this: > > [junit] 19:07:02.162 ERROR [ ] util.JDBCExceptionReporter >> (JDBCExceptionReporter.java:101) Syntax error in SQL statement " >> [junit] CREATE TABLE GAME >> [junit] ( >> [junit] ) CHARSET[*]=UTF8 "; SQL statement: >> [junit] >> [junit] create table Game >> [junit] ( >> [junit] ) charset=UTF8 [42000-170] > > > It would be very helpful if it could accept this. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/VKBTNcU3SYIJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
