Turkish Characters Problem

[xistanbulsuaritman]

Turkish Characters Problem, help us. Thanks.

Char: ÖÇŞİĞÜ – öçşiğü

[peterlaursen]

1) Please detail the problem. Alos tell what SQLyog version you are using

2) Please read this FAQ: http://webyog.com/faq/content/34/152/en/my-special-characters-display-as-_noisy_-latin-characters-in-sqlyog.html

3) I assume that some characters display otherwise than expected. Is that also the case if data are inserted using SQLyog?

4) paste the returns of SHOW CREATE TABLE for an affected tabel here

5) Also it would be nice if you attached a small SQL dump from an affected table here. The dump must be made by a client that generates UTF(-encoded dumps (what SQLyog does).

[peterlaursen]

Ok .. I can find a problem. In SQL:

SET NAMES utf8;

DROP TABLE IF EXISTS turkish;

CREATE TABLE `turkish` (

`id` INT(10) NOT NULL,

`col1` VARCHAR(20) CHARACTER SET latin7 DEFAULT NULL,

`col2` VARCHAR(20) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO turkish VALUES (1, ' ÖÇŞİĞÜ – öçşiğü' , 'ÖÇŞİĞÜ – öçşiğü');

SHOW WARNINGS; — Warning Code : 1366 – Incorrect string value: 'xC3x87xC5x9ExC4xB0…' for column 'col1' at row 1

SELECT * FROM turkish;

/* I get

Code:

id col1 col2
—— ——————– ————————–
1 Ö????Ü – ö??i?ü ÖÇŞİĞÜ – öçşiğü

*/

In that case it looks like a problem with the latin5 character set in MySQL. (tried both 5.1.58 and 5.5.15)

As far as I can understand this: http://en.wikipedia.org/wiki/Turkish_alphabet the characters you write are valid in Turkish and should be in mySQL latin5 charset as well.

It that is the problem I see only the workaround to use UFT8.

[peterlaursen]

Ooops .. I did a mistake. latin7 is Baltic – not Turksih. With latin5 it works fine for me:

SET NAMES utf8; — client (SQLyog) uses utf8 internally

USE test;

DROP TABLE IF EXISTS turkish;

CREATE TABLE `turkish` (

`id` INT(10) NOT NULL,

`col1` VARCHAR(20) CHARACTER SET latin5 DEFAULT NULL,

`col2` VARCHAR(20) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO turkish VALUES (1, ' ÖÇŞİĞÜ – öçşiğü' , 'ÖÇŞİĞÜ – öçşiğü');

SELECT * FROM turkish;

/* returns

Code:

id col1 col2
—— ————————— ————————–
1 ÖÇŞİĞÜ – öçşiğü ÖÇŞİĞÜ – öçşiğü

*/

So still we need you to detail your problem! And for completeness also please tell the server version you are using.

[Author]

Posts