google-code-export / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
1 stars 1 forks source link

Column Collation? #141

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Could you add collection when add new column 
like" latin1_swedish_ci  " utf8 " etc..

Thanks

Original issue reported on code.google.com by most...@syntaxeg.com on 10 Dec 2011 at 10:40

GoogleCodeExporter commented 9 years ago
Hm, that is a DB-specific feature, not sure how to incorporate that.

Original comment by ondrej.zara on 4 Jan 2012 at 2:26

GoogleCodeExporter commented 9 years ago
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

Original comment by celebi.o...@gmail.com on 30 Jan 2012 at 1:25

Attachments:

GoogleCodeExporter commented 9 years ago
alright fix'd it sry :)

Original comment by celebi.o...@gmail.com on 30 Jan 2012 at 1:30