Toad World® Forums

Where to declare columns character set

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.

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

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

Thanks! It was right there!!!

You’re welcome!