[vickle]

Depending on Windows to choose charater set would likely lead to misbehaviour, and breaks the persistence of the program. That really is a bad design.

I often have to tackle Simplified Chinese, Traditional Chinese and Janpanese charaters, all of which are in different encodings, at the same time, so the problem is significant to me.

Well ……… I haven't tried SQLyog 3.5. Does it do the job now?

It is too bad SQLyog goes non-free. 🙁

[vickle]

“because SQLyog is influenced by Windows settings. “

…….. did you mean SQLyog would use different default char set depending on Windows version? 😕

In my case, in order to handle multilingual texts, I would like to set the char set in the MySql db to be unicode/utf8, where the default is latin1, as does SQLyog, i think. So here comes the situation where the server and its client are in different char set/encodings, and what would happen if I input/update data from SQLyog but no way to tell in what encoding the actual data are?

Since SQLyog is an admin tool for MySql, It needs some features to handle different char sets definitely. 😎

[vickle]

mysql supports charater set handling by setting individual database/table/column a default charater set, through certain extra sql statement syntax. I think sqlyog should at least provide some facitlities to set such properties when creating / altering a table.

also mysql supports that database server and the client (such as sqlyog) can have different charater sets. I think such features so important to use mysql in modern applications.

😆 what do you think ?

[vickle]

😡

Hey, I got the same problem here, but my case is with Access.

When I import a table from a odbc dns which links to an access mdb file, and some fields of the table have spaces in their names, the error occurs, exactly the same as mentioned above.

The error persists until I manually changed those those field names eliminating all the spaces therein.

Since both MySql and Access support field names with spaces, I think it is a bug in SQLyog.

Any suggest?

[Author]

Posts