Where to declare columns character set

Toad Data Modeler
1

I couldn’t find the answer to this. in my ER diagram I’ve a MySQL table where I would like to declare a different character set but I don’t see how to declare it on TDM.

This is how the column should be declared:
pId varchar(350) CHARACTER SET latin1 COLLATE latin1_bin

Where character set and collate is defined at column level. I’m using TDM 3.6.
Thanks in advance.

2

Hi Ricardo,

just try editing the attribute you want to set the character set for, see the screenshots.

You can do the same for the whole table on the Table Options tab.

Regards,
Lukas

mysqlAttributeCharSet.png
mysqlAttributeCharSet.png487×600 29.1 KB

3

Hi Ricardo,

just try editing the attribute you want to set the character set for, see the screenshots.

You can do the same for the whole table on the Table Options tab.

Regards,
Lukas
mysqlAttributeCarSQLprev.png

4

Thanks! It was right there!!!

5

You’re welcome!