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