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: | |
Category: | Connector / ODBC | Severity: | S1 (Critical) |
Version: | 5.1 | OS: | Windows (Win2000) |
Assigned to: | CPU Architecture: | Any |
[11 Jul 2005 0:28]
Omer YILDIRAN
[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.