ok - sorry I made that small typo with the " and '... I have updated my post to fix this and made it clearer by using QUOTEs instead of quote marks " " (thanks for pointing that out).
umm interesting that "ALL" does not work for V4.2.X (and they have to list out the "COLLATE", "CTYPE" etc.).
The other interesting thing is that your default store language (i.e. not 2nd language) must now be GR - this is why the change is needed for the 'el_GR.UTF8' - as that is only used if you deleted English off your system totally and replaced it with Greek as the default.
e.g. if default language installed was UK - then it would be 'en_GB...' (English / Great Britian) and not 'en_US...' (English / US)
I made this comment so other users reading understand why this part of code might need to change, if they change the default language of their store to something other than English (note: this does not mean only the changing in X-Cart Admin of default language to show is "English" or "Greek"... i.e. the default "setting" in Admin) - it means at some stage you deleted English from your store and only had a new language Greek installed).
Now your default language (i.e. not 2nd language) is 'el_GR...' (Greek / Greece).
Logic behind this is that default language is installed in e.g. xcart_products SQL table and 2nd language is stored in xcart_products_lng SQL table... (so in this logic, you have changed the "default" langage text used in "xcart_products" to be Greek).
Hope that makes sense to those who need to understand this - lol
Glad to hear you have fixed the problem (once again, sorry my code didn't work first time around for you)... and thanks also for posting your solution here, so others can benefit as well - great!!!
Cheers, Asiaplay