I think that I have pinpointed where the problem might be, in the file sql.php under the folders mod/glossary the case that shows the entries in my glossary is this:
$where = 'AND left(ucase(concept),' . strlen($hook) . ") =
'" . strtoupper($hook) . "'";
ORDER BY `concept` ASC
LIMIT 0 , 30
My table is incorrect as far as the arrengement of the entries and by that I mean that the entries are incorrect in comparison with the arrangement of the greek alphabet.
First of all I think that I have now found what the problem is, MySql cannot arrange greek words in the right order.
Has anyone encountered a problem like this before with a language that doesn't uses the latin alphabet, I can't understand why MySql has a trouble doing this because it seems that it doesn't have a problem with the greek language.
Is it because of the version of MySql that I use? I use EasyPhP for this local installation that I have for tests, which had in it a version of MySql, and on my site I use the 4.0.25v of Mysql but the problem is the same.
Should I use some other kind of sql query? But every query that I use, with a different order I mean, doesn't give me the proper arrangement.
Best regards to all Panayiotis Iliopoulos.