Book a Demo

Author Topic: Database DDL with Table charset (Mysql) ?  (Read 3915 times)

Kramer

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
  • Using EA since 05/2005
    • View Profile
Database DDL with Table charset (Mysql) ?
« on: December 01, 2005, 12:21:08 am »
There is possibility to specify table Type and Owner using tagged values.
I need to set table Charset. I tried tagged value Charset=utf8 but it doesn't come up in generated DDL as "DEFAULT CHARSET" :(

I need it like this:
CREATE TABLE `x` (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Is there a way to configure transformation template for that or something?

Or Sparx will consider this as feature request? Please implement this in the next build !

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Database DDL with Table charset (Mysql) ?
« Reply #1 on: December 01, 2005, 01:29:47 pm »
Create tags in the same way as for table type...

Use Tags:
CHARACTER SET (or CHARSET)
COLLATE

and enter the appropriate values.

Kramer

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
  • Using EA since 05/2005
    • View Profile
Re: Database DDL with Table charset (Mysql) ?
« Reply #2 on: December 02, 2005, 10:53:04 am »
This is exactly what I do!
I enter CHARSET tagged value and it does not produce anything in DDL.
Type works fine on the same table.

Are you sure CHARSET supposed to work? Maybe we need to upgrade? Using 772 now.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Database DDL with Table charset (Mysql) ?
« Reply #3 on: December 04, 2005, 05:56:39 pm »
This option was available from build 775.