php with georgian letter
Posted by:
john lee
Date: May 06, 2011 12:45AM
Hi,
our site is in géorgian and we have a search form on it.
But when we make search with georgian text ()different alphabet), mysql don't return any result. We try from a php script and from phpMySql, and result is the same, with request such as LIKE "%იყიდება%" or with full MATCH (Annonce_En_Langue_Titre, AEL0.Annonce_En_Langue_Texte) AGAINST ("იყიდება").
DOes anyone could help help ?
Do we need special encoding for it ?
here the scheme of our table :
CREATE TABLE IF NOT EXISTS `GeorgieAnnonce_En_Langue` (
`Annonce_Id` varchar(20) NOT NULL DEFAULT '',
`Langue_Id` int(10) unsigned NOT NULL DEFAULT '0',
`Annonce_En_Langue_Titre` text,
`Annonce_En_Langue_Texte` text,
`Annonce_En_Langue_Date_Validation` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`Annonce_Id`,`Langue_Id`),
KEY `fk_GeorgieAnnonce_En_Langue_Annonce` (`Annonce_Id`),
KEY `fk_GeorgieAnnonce_En_Langue_Langue` (`Langue_Id`),
KEY `Annonce_En_Langue_Date_Validation` (`Annonce_En_Langue_Date_Validation`),
FULLTEXT KEY `Annonce_En_Langue_Titre` (`Annonce_En_Langue_Titre`,`Annonce_En_Langue_Texte`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Thanks