Re: [eclipselink-users] Character set / encoding in tables ?

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Kaspar,

  JPA table creation is intended to provide some basic table creation.  If you 
want something that goes beyond the basics, I suggest you use EclipseLink to 
output the DDL generation statements and then edit them to be what you want.

  You can do that by setting the following properties in your persistence.xml.

"eclipselink.ddl-generation" can be set to either "create-tables" or 
"drop-and-create-tables"

"eclipselink.ddl-generation.output-mode" can be set to "sql-script"

"eclipselink.create-ddl-jdbc-file-name" and 
"eclipselink.drop-ddl-jdbc-file-name" should be set to the appropriate file 
location.


-Tom

Kasper Hansen wrote:
> Hi,
>
> I can't seem to find anywhere to set what encoding I want in my tables 
> (the DEFAULT CHARSET statement after a create table) ? Right now it's 
> defaulted to "latin1" in my mySQL database. I would like it to be UTF-8.
>
> Also, where do I specify InnoDB engine, and not the default MyISAM, if I 
> want that (the ENGINE statement after a create table) ?
>
> Thanks,
>
> :-) Kasper
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users