non English chars in field comments get corrupted when importing database

[GoogleCodeExporter]

Some comments in MySQL fields are not well processed when saving XML ER-
diagrams:

- If you use non-english characters inside a field comment, they got 
corrupted when you save the XML (i.e., "ñ" of "España" got changed to 
"España"). There are MANY of these errors when the designer does not use 
English language.
Perhaps this is something related to character encoding of wwwsqldesigner 
and is possible to modify. Any hints?

- If you add some html tags inside a comment (I use this for adding a link 
to a better description of the field), the XML will be invalid. This is 
obvious but perhaps it is possible to escape "<" and ">" somehow?

Original issue reported on code.google.com by dgsanl...@gmail.com on 13 May 2010 at 6:30

[GoogleCodeExporter]

I have to rectify. For some reason I don't understand, my character encoding 
was 
looking wrong the first 3 or 4 times I tried to import a database with 
wwwsqldesigner.

Today I created brand new mysql schemas just for testing, and imports are 
working 
perfectly (all spanish tildes and accents seem to be OK).

I am sorry for opening this issue (the html tags are quite important in my 
schemas, 
tough, so I would like to keep using them if possible)

Original comment by dgsanl...@gmail.com on 14 May 2010 at 12:34

[GoogleCodeExporter]

This is probably related to your DB encoding/collation configuration. 
WWWSQLDesigner
posts all its data as UTF-8 (this will not change), so your DB must match this.

Original comment by ondrej.zara on 14 May 2010 at 7:08