We need to update the charset for some tables (and the database) in some
of our current Mayfly usage with commands like:
1) ALTER TABLE XYZ CHARSET = utf8, ENGINE=InnoDB;
2) ALTER DATABASE ABC CHARSET = utf8 COLLATE utf8_unicode_ci;
Unfortunately, I believe that both the CHARSET and ENGINE keywords are
MySQL specific. I'm not sure what the best way to deal with the need
for changes like these is with respect to Mayfly. Any thoughts on this
would be appreciated and if there is a change that could be made to
Mayfly to support this, that would be great too.
When trying to run the first command in Mayfly, we get the following
output:
Caused by: net.sourceforge.mayfly.MayflySqlException:
expected alter table action but got CHARSET
at
net.sourceforge.mayfly.MayflyException.<init>(MayflyException.java:47)
at
net.sourceforge.mayfly.parser.ParserException.<init>(ParserException.jav
a:8)
at
net.sourceforge.mayfly.parser.ParserException.<init>(ParserException.jav
a:16)
at
net.sourceforge.mayfly.parser.Parser.parseAlterTable(Parser.java:587)
at
net.sourceforge.mayfly.parser.Parser.parseCommand(Parser.java:257)
at
net.sourceforge.mayfly.parser.Parser.parse(Parser.java:212)
at
net.sourceforge.mayfly.evaluation.command.Command.fromSql(Command.java:2
2)
at
net.sourceforge.mayfly.MayflyConnection.execute(MayflyConnection.java:62
)
at
net.sourceforge.mayfly.jdbc.JdbcStatement.executeUpdate(JdbcStatement.ja
va:32)
Thanks,
--Van
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
