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
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