Bug #1554 character set latin5 error

• Submitted: 15 Oct 2003 2:58
• Modified: 1 Jun 2004 0:31
• Reporter: Mustafa Tan
• Status: Closed
• Category: MySQLCC
• Severity: S2 (Serious)
• Version: 0.9.3
• OS: Windows (windows 2000 pro)
• Assigned to: Jorge del Conde
• CPU Architecture: Any

[15 Oct 2003 2:58] Mustafa Tan

Description:
if mysql server character set is latin5, mysqlcc throws an exception (ERROR 1193: Unknown system variable 'SQL_SELECT_LIMIT') while trying to connect to server.

any other management gui's for mysql (included mysqlgui 1.7.5.2) works fine but the mysqlcc.

my.ini file:

[mysqld]
basedir=C:\mysql
#bind-address=10.10.100.105
datadir=C:\mysql\data
default-character-set=latin5
#character-sets-dir=C:\mysql\share\charsets
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
user=AURORA
password=AURORA

How to repeat:
change the default-character-set to latin5 and restart server and try to connect with mysqlcc.

Suggested fix:
in turkish (latin5) character set, upper case of letter "i" is "Ý" and upper case of letter "ý" is "I". this may cause the error.

[15 Oct 2003 4:48] Alexander Keremidarski

What varsion if MySQL server do you use?

[15 Oct 2003 5:20] Mustafa Tan

mysql server version : 4.0.15

[16 Nov 2003 16:34] MySQL Verification Team

Thank you for the bug report I was able to repeat.

[1 Jun 2004 0:31] Jorge del Conde

Hi!

MySQLCC will not be developed nor maintained anymore with the exception of Critical bugs.

In the near future we will release the substitute of MySQLCC called MySQL Query Browser.