Function Charset Problem

[mkysoft]

I try to make functions which is included spacial characters in latin5 (turkish). Webyog doesn't open function correctly. It shown latin5 characters like “?”. I open mysql.proc table and edit “body” field in blob editor (because this field is longblob) for correct these characters. Then its working. What is the problem can be? I select default charset on connection screen but didn't working. I try 5.11 and 5.2 Beta 3.

Thanks.

[peterlaursen]

did you go to tools..preferences..editor and selected a turkish script with the font(s) for the editor and the and the DATA tab? There is a dropdown where to choose!

[mkysoft]

Yes. I did this settings before. I checked it again.

[peterlaursen]

OK .. now what happens if you choose 'latin5' from the connections manager? If the default charset on your server is latin1 (very common everywhere around the world!) you must choose 'latin5' yourself.

Also is Turkish set as the default language for non-unicode programs? And is it a Turkish Windows or an English?

Please try to understand this:

http://www.webyog.com/faq/34_102_en.html

Actually the current charset setting system of SQLyog was first tested succesfully with Turkish!

what does

Code:

SHOW variables like '%character%';

return on you system when connected?

[mkysoft]

I run

Code:

SHOW variables like '%character%';

then sqlyog show this result.

Code:

“Variable_name” “Value”
“character_set_client” “latin5”
“character_set_connection” “latin5”
“character_set_database” “latin5”
“character_set_filesystem” “binary”
“character_set_results” “latin5”
“character_set_server” “latin5”
“character_set_system” “utf8”
“character_sets_dir” “C:\Program Files\mysql\share\charsets\”

my default language latin5 in mysql. I setup it in my.ini file. Also my windows is Turkish. I can see turkish character correctly in Sqlyog when running SQL for selecting data from tables. For example;

Code:

select 'ş ç ğ ı ü ö İ Ü Ö Ğ' as latin5

This code working properly.

Then I try this:

Code:

show create function test

My 'ş ç ğ ı ü ö İ Ü Ö Ğ' characters showing '? ? ? ? ? ? ? ? ?'

I think this is not Sqlyog problem, its caming from MySQL. Thanks. I am sorry because of I must try before.

[peterlaursen]

Quote:

show create function test

My 'ş ç ğ ı ü ö İ Ü Ö Ğ' characters showing '? ? ? ? ? ? ? ? ?'

I think this is not Sqlyog problem, its caming from MySQL. Thanks. I am sorry because of I must try before.

No I think it is a SQLyog issue. But starting from Beta4 we also have charset settings that are effective for RESULT tab.

[Author]

Posts