MySQL Bugs: #17473: Problem about Turkish character encoding

Bug #17473	Problem about Turkish character encoding
Submitted:	16 Feb 2006 15:33	Modified:	17 Mar 2009 22:03
Reporter:	Sebahattin Erdem	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Hello;

We can not take Turkish standby. We are doing export mysql 4.xx and 5.xx. It give us false character. 

For Example;
ı --> ý
ş --> þ
İ --> Ý
ö --> ð

We are making All Turkish characters but is it not working true.

Note: Mysql 3.xx is true working. It give me all Turkish characters.

Thank you...

How to repeat:
When we export database.

Example

Attachment: example.htm (text/html), 405 bytes.

Thank you for a problem report. Please, send the my.ini file from your 5.xx server.

Exect versions will be also useful. Was it exported from 4.0.x or 4.1.x?

Please you look it. http://www.yeniklasor.com/dosyalar/example.gif

My server was 3.xx, mysql worked true. It is was 4.xx and 5.xx it is not working true. Sorry for my English :(

Oh! and one thing, I use now latin_1_swedish, it is true working when I import, but when I export, it is not working true for Turkish characters. And I used all Turkish  Character Sets and Collations (latin5_turkish_ci, ucs2_turkish_ci , utf8_turkish_ci... ) and they aren't working true. 

I'm sory I am using so my computer mysql 3.xx, but my hosting use 5.xx . I am going to phone my server for .ini file... Thanks all things...

Hi Sebahattin,

your example (example.htm) is working correct for me, when using iso-8859-9 character set for displaying. Please check you client side character settings.

See example2.htm.

Regards, Hakan

Corrected characterset

Attachment: example2.htm (text/html), 403 bytes.

Screenshot of corrected character set

Attachment: charset_client.png (image/png, text), 40.42 KiB.

Hey Man it is only a html. Of course It is true working with Turkish (windows or Iso)characters. I know it so I made a gif. You have to look it.

Hello Sabahattin,

please double check your client side character settings.

Is example.htm an output from your application or just an example for the behaviour you are experiencing?

Could you provide us with a reproducable testcase for the behaviour you described?

See this html files with unicode or Europan. I wrote it for English Browsers.

OK Very Thanks