Column Collation?

[ondras]

From most...@syntaxeg.com on December 10, 2011 11:40:30

Could you add collection when add new column
like" latin1_swedish_ci " utf8 " etc..

Thanks

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=141

[ondras]

From ondrej.zara on January 04, 2012 06:26:57

Hm, that is a DB-specific feature, not sure how to incorporate that.

[ondras]

From celebi.o...@gmail.com on January 29, 2012 17:25:41

Hi there,

I don't know if other DB's have this feature but in MySQL column's have collations too, which is actually very important.
Even if the table has utf8_bin as collation if the column does not have it, it doesn't show the special chars right.

Something like:

ALTER TABLE [table_name]
MODIFY [column_name]
VARCHAR(5)
CHARACTER SET utf8
COLLATE utf8_bin;

could be done for each row.

Furthermore i changed the output.xsl to do this. But it seems that somehow my changes in the .xsl are being ignored Òó "sqldesigner/db/mysql/output.xsl".
I also removed the SQL comment marks "-- " infront of "ALTER TABLE ..." in Table Properties, but thats also being ignored.
It is generating the same sql code, not the one I want.
If there is anything unclear of what i want to achieve just ask :)
Attached is the modified output.xsl

Attachment: output.xsl

[ondras]

From celebi.o...@gmail.com on January 29, 2012 17:30:43

alright fix'd it sry :)