Bug #543 multi lanuage table search error
Submitted: 29 May 2003 17:32 Modified: 30 May 2003 4:18
Reporter: Mina Waheb Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:4.1 OS:Microsoft Windows (Windows XP , FreeBSD)
Assigned to: CPU Architecture:Any

[29 May 2003 17:32] Mina Waheb
Description:
i have cerate table types then table singers witch extends on types LIKE thats

CREATE TABLE `singers` (
  `id` mediumint(7) unsigned zerofill NOT NULL auto_increment,
  `type` mediumint(3) NOT NULL default '0',
  `name` varchar(150) NOT NULL default '',
  `pic` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `name` (`name`),
  FOREIGN KEY (`type`) REFERENCES `types` (`id`)
) TYPE=InnoDB; 

then i insert some rows with multi language ( arabic + english )
while i try to search in english its work quickly fine ,
here is the problem while i try to search for rows in arabic language its display rows in english language. with impossible result near from what i search for.

i was search for test by "Select * from singers where name LIKE '%$key%'" using PHP script 

some rows from my table witch near from the error :

INSERT INTO singers VALUES("0001578","11","duane allman","1");
INSERT INTO singers VALUES("0001579","11","duane eddy","1");
INSERT INTO singers VALUES("0002156","11","guano apes","1");
INSERT INTO singers VALUES("0002836","11","juan gabriel","1");
INSERT INTO singers VALUES("0002837","11","juan luis guerra","1");

i dunno if your browser support arabic lanuage but i will post some inserted rows from what i search for 

INSERT INTO singers VALUES("0006438","12","ÚãÑæ ÏíÇÈ","0");

after you insert the rows try to select 

Query ( select * from singers where name LIKE '%ÚãÑ%'; )

this query will display all the table rows :(

wish to find solve coz this error cost me work of 2 months :(((

thank you so much

How to repeat:
every thing is up

Suggested fix:
every thing is up
[29 May 2003 18:19] Mina Waheb
i test it too in MyISAM and not work too if the table have multi language or have only one language in the varchar rows :(((
[29 May 2003 18:49] Mina Waheb
im sorry i found this is my problem i was have use BINARY select im sorry again for bother
[30 May 2003 4:18] Alexander Keremidarski
Thank you for your time.