MySQL Forums
Forum List  »  MyISAM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
php with georgian letter
4189
May 06, 2011 12:45AM
1481
May 07, 2011 03:18PM
1532
May 07, 2011 05:03PM
1467
May 07, 2011 11:14PM
1335
May 08, 2011 03:01AM
2016
May 09, 2011 12:40AM
1290
May 09, 2011 01:38AM
1350
May 09, 2011 03:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.