Bug #11852 SELECT * FROM $table$ WHERE name LIKE 'İ%'
Submitted: 11 Jul 2005 0:28 Modified: 23 Oct 2007 13:26
Reporter: Omer YILDIRAN Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:5.1 OS:Windows (Win2000)
Assigned to: CPU Architecture:Any

[11 Jul 2005 0:28] Omer YILDIRAN
Description:
i get "i..." and "y..." words for this sentence. it is a critical error for me. how can i fix it? when you will be?

How to repeat:
always does it
[11 Jul 2005 6:24] Vasily Kishkin
Could you please write here table definition of your table ? What coding do you use ?
[11 Jul 2005 13:00] Omer YILDIRAN
# Host: localhost
# Database: guvenlik
# Table: 'personel'
# 
CREATE TABLE `personel` (
  `sira` int(6) unsigned NOT NULL auto_increment,
  `kurumsirket` int(6) unsigned NOT NULL default '0',
  `kurumsirketgorev` int(6) unsigned NOT NULL default '0',
  `adisoyadi` varchar(50) NOT NULL default '',
  `baba` varchar(20) NOT NULL default '',
  `kimlikno` double(11,0) unsigned NOT NULL default '0',
  `verilis` date NOT NULL default '2005-01-01',
  `gecerlilik` date NOT NULL default '2005-01-01',
  `silah` tinyint(1) NOT NULL default '0',
  `dogumtarihi` date NOT NULL default '2005-01-01',
  `dogumyeri` varchar(50) NOT NULL default '',
  `kayitliil` int(3) unsigned NOT NULL default '0',
  `kayitliilce` int(5) unsigned NOT NULL default '0',
  `kan` tinyint(1) NOT NULL default '0',
  `yenileme` date NOT NULL default '2005-01-01',
  `onayiptaltarihi` varchar(10) NOT NULL default '',
  `onayiptalnedeni` varchar(100) NOT NULL default '',
  `calisma` varchar(100) NOT NULL default '',
  `onay` tinyint(1) unsigned NOT NULL default '1',
  `iptal` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`kimlikno`),
  UNIQUE KEY `no` (`sira`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[11 Jul 2005 13:12] Omer YILDIRAN
i can put the "İ"(I with a dot at top of) and the "Y" character separately. but i can't get. it sends "İ..." and "Y..." for 'İ%' and 'Y%'.
[12 Jul 2005 3:39] Jorge del Conde
I wasn't able to reproduce this bug using Latin1 characters.
[23 Oct 2007 13:26] Susanne Ebrecht
This is a duplicate of bug #28817.