MySQL Bugs: #51442: Let configure ResultSet Charset and Collation for SQLEditor

Bug #51442	Let configure ResultSet Charset and Collation for SQLEditor
Submitted:	24 Feb 2010 3:55	Modified:	29 Apr 2010 18:36
Reporter:	Carlos Pereira	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.16 OSS Rev 5249	OS:	Windows (XP SP3 Spanish)
Assigned to:		CPU Architecture:	Any
Tags:	charset, collation, ResultSet, sql editor

Description:
Hi

I am trying to determinate if my php web app is saving on iso-8859-1(latin1) on MySQL 5.1.43-community!! In the web page look perfect but when I make queries from SQLEditor characters like ñ or ó look like a square???

What is the reason?? There are one way for configure the default charset or collation for SQL editor result set displayer???

How to repeat:
Try to put some ñ or ó in a table with latin1 charset and latin1_spanish_ci collation and then view with SQLEditor???

Suggested fix:
Let a way for configure charset and collation for sqleditor resultset displayer!!!

i can see chars like the ones mentioned display properly on my xp and win7 boxes (connected to 5.1.39).
could you maybe provide a short dump of a demo table thats causing these problems?

Yeah I would like to do but I don´t know how to make a table dump??
Could you tell me how??

And, I discover that if I realize the insert query directly in SQLEditor the characters ñ or ó don't present problems when display in SET NAMES 'latin1', but I realize the same insert on my iso-8859-1 web app I sufer this character problem!!!

Please, send the results of:

show session variables like 'char%';

from SQL Editor.

Variable_name 	                Value
character_set_client 	        latin1
character_set_connection 	latin1
character_set_database 	        latin1
character_set_filesystem 	binary
character_set_results 	        latin1
character_set_server 	        latin1
character_set_system 	        utf8
character_sets_dir 	        E:\Archivos de programa\MySQL\MySQL Server 
                                5.1\share\charsets\

To provide a dump file of sample table take a look in the Manual:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".