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;