Re: MySQL compatibility with CREATE engine & charset

[Stig Brautaset]

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.

[Noel Grandin]

On Wednesday, 12 December 2012, Stig Brautaset wrote:

I raised an issue in the issue tracker for this:

http://code.google.com/p/h2database/issues/detail?id=431

Patches welcome.