Product Version: NetBeans IDE Dev (Build 200802191203)
Java: 1.6.0_03; Java HotSpot(TM) Client VM 1.6.0_03-b05
System: Windows XP version 5.1 running on x86; MS932; ja_JP (nb)
Below is the extract from the list of variables of the server environment:
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci
1. Connect to My SQL server fro the IDE
2. Try to create a table using mbyte in its name
3. Try to create a table with the same name
There is an err message with bad mbyte. Probably it is expected behavior but the message shouldn't contain
bad mbyte in it. I'm running in the Japan locale, using a pseudo localized Netbeans.
Created attachment 57476 [details]
Created attachment 57477 [details]
This is a bug in the MySQL error message. I don't believe it makes sense for me to disable the error message just
because there are some bad characters. I believe in general the error message is useful. If you want you could log a
bug with MySQL. See http://bugs.mysql.com/
I found another message. Does it related to MySQL error messages also?
If the name of a table has more then 6 multibyte chars it will be truncated by 'E' at the end and shown under the
'Tables' node. (see image) For this kind of tables delete action doesn't work and err message with square boxes appears.
Also I can't expand table node to see tables columns.
Created attachment 60809 [details]
It looks close to http://bugs.mysql.com/bug.php?id=1406