How to generate the charset clause for an att?

[ericv]

Hi,

I need to generate the MySQL charset clause for an attribute of a table in a data model.

For example:
CREATE TABLE tabname

(
 
attname VARCHAR(255) CHARACTER SET utf8 NOT NULL DEFAULT ''

) DEFAULT CHARSET latin1;

I have added a Custom Tagged Value 'CHARSET' on the table and it has worked fine.

But when I tried to apply the same method on the attribute,  nothing has been produced by the DDL generation.

I use EA 6.1.788.

Thanks for your help.
~~~
Eric

[hd]

This is not available yet for MySQL columns.

We will add this feature in a future release.

[ericv]

Hi,

What's new about this feature ?

Now I use the version 6.5 802, is it possible to add the character set clause for a column ?

Thanks.
~~~
Eric

[«Midnight»]

Don't know Eric.

If not, you might be able to work around this somehow. Perhaps add a tagged value to the column element. Then tweak the generation script to check for the tag, and if it is present insert the clause using the value.

[Of course this would require direct access to the SQL generation function in EA. I don't remember off hand, but this might not be scripted, and thus impossible for use poor end users. Perhaps someone can shed some light on this.]

David