Bug #20063 UTF8 turkish
Submitted: 25 May 2006 9:01 Modified: 27 Dec 2006 15:21
Reporter: soner sivri Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.1.20 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: Generic

[25 May 2006 9:01] soner sivri
Description:
i update text fields which has CHARSET=utf8 COLLATE=utf8_turkish_ci
i updated 2 rows with no problem.
but after second row fields not updated correctly (Ş is problem)
my table description is under

CREATE DATABASE /*!32312 IF NOT EXISTS*/ muhasebe;
USE muhasebe;

CREATE TABLE `muh_tbl_doc` (
  `sira_no` int(10) unsigned NOT NULL auto_increment COMMENT 'SIRA NUMARASI',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` int(10) unsigned NOT NULL default '0',
  `aciklama` varchar(45) NOT NULL default '',
  `forum` int(10) unsigned NOT NULL default '0',
  `dosya` longblob NOT NULL,
  `dosya_isim` varchar(45) NOT NULL default '',
  `dosya_icerik` longtext NOT NULL,
  PRIMARY KEY  (`sira_no`),
  KEY `FK_muh_tbl_doc_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci COMMENT=' MYISAM free: 11264 kB; (`type`) REFER `muhasebe/muh_tbl_doc';

CREATE TABLE `muh_tbl_doc_type` (
  `type` int(10) unsigned NOT NULL auto_increment,
  `type_desc` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;

How to repeat:
i update text fields which has CHARSET=utf8 COLLATE=utf8_turkish_ci
i updated 2 rows with no problem.
but after second row fields not updated correctly (Ş is problem)
my table description is under

CREATE DATABASE /*!32312 IF NOT EXISTS*/ muhasebe;
USE muhasebe;

CREATE TABLE `muh_tbl_doc` (
  `sira_no` int(10) unsigned NOT NULL auto_increment COMMENT 'SIRA NUMARASI',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` int(10) unsigned NOT NULL default '0',
  `aciklama` varchar(45) NOT NULL default '',
  `forum` int(10) unsigned NOT NULL default '0',
  `dosya` longblob NOT NULL,
  `dosya_isim` varchar(45) NOT NULL default '',
  `dosya_icerik` longtext NOT NULL,
  PRIMARY KEY  (`sira_no`),
  KEY `FK_muh_tbl_doc_type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci COMMENT=' MYISAM free: 11264 kB; (`type`) REFER `muhasebe/muh_tbl_doc';

CREATE TABLE `muh_tbl_doc_type` (
  `type` int(10) unsigned NOT NULL auto_increment,
  `type_desc` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
[25 May 2006 15:19] Jorge del Conde
Thanks for your bug report.  I was able to reproduce this by using the how-to-repeat posted in the original bug report.
[27 Nov 2006 15:21] Valeriy Kravchuk
Please, try to repeat with a newer version, 1.2.6 beta (from GUI Tools 5.0r6), and inform about the results.
[28 Dec 2006 0:00] Bugs System
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".