Bug #1554 character set latin5 error
Submitted: 15 Oct 2003 2:58 Modified: 1 Jun 2004 0:31
Reporter: Mustafa Tan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.3 OS:Microsoft Windows (windows 2000 pro)
Assigned to: Bugs System 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] Miguel Solorzano
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.