Page 2 of 2
Re: Search Module - Greek Search
Posted: Fri Oct 27, 2006 2:52 pm
by tsiger
actually the line i mentioned before is :
Code: Select all
$ary[] = "word = " . $db->qstr($word);
Re: Search Module - Greek Search
Posted: Fri Oct 27, 2006 3:11 pm
by jozef
no, its more tricky. Do not use FCKEditor. Regardless the settings in its config file, the content from FCK is always being encoded with hmlentities.
The only working solution for MySQL 4.1 or MySQL 5 with collation utf8_general_ci:
- always connect to MySQL with utf8. Patch the include.php file; add this line:
after line
- do not use FCKEditor
- in the file action.dosearch.php i replaced this line :
Code: Select all
$ary[] = "word = " . $db->qstr(htmlentities($word, ENT_COMPAT, 'UTF-8'));
with this:
Code: Select all
$ary[] = "word = " . $db->qstr($word);
Resume: Core developers, please read the articles i posted, and remove htmlentities from CMSMS. Use TinyMCE, if i remember TinyMCE has a config option "raw" which really stores content in utf8.
Re: Search Module - Greek Search
Posted: Fri Oct 27, 2006 3:14 pm
by tsiger
cool
Re: Search Module - Greek Search
Posted: Fri Oct 27, 2006 3:19 pm
by jozef
tsiger, it was a nice collaboration
What about my multilingual problem? Do you have any tips?
Re: Search Module - Greek Search
Posted: Fri Oct 27, 2006 3:28 pm
by kode_fi
Thank's guys!!!
Searching works now as it should even when content is not encoded HTML entities. This was BIG problem for my project, but now it's solved.
You really saved my weekend!!!
Teemu
Re: Search Module - Greek Search
Posted: Mon Oct 30, 2006 8:45 am
by tsiger
Hey jozef
This is the first time using cmsmadesimple and i will need multilingual support for sure. At the point i get there i ll be the first to post my tips