I raised an issue in the issue tracker for this: http://code.google.com/p/h2database/issues/detail?id=431
Stig On Tuesday, 11 December 2012 16:10:08 UTC, Stig Brautaset wrote: > > 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/-/SE-OehNlnbcJ. 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.
