gegeor Posted January 15, 2010 Posted January 15, 2010 Hi all I gave a problem with the search in oscommerce (ver. 2.2).This is the error i get: ----------------------- 1267 - Illegal mix of collations (greek_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like' select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c,products_attributes pa where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%δδδδ%' or p.products_model like '%δδδδ%' or m.manufacturers_name like '%δδδδ%') ) [TEP STOP] ---------------------- site language is Greek and this problem is only when i perform search with Greek word. I have tried varius "solutions" through searching the error in Google but nothing worked... Any ideas please? Your help is valuable Many thanks George
jdvb Posted January 15, 2010 Posted January 15, 2010 go to phpmyadmin (tool probably provided by your hoster) and change the collation on all tables to be the same.
gegeor Posted January 15, 2010 Author Posted January 15, 2010 go to phpmyadmin (tool probably provided by your hoster) and change the collation on all tables to be the same. Thanks for your reply In which collation should i change? My language file has iso-8859-7 and the language i use is Greek Thanks
gegeor Posted January 27, 2010 Author Posted January 27, 2010 go to phpmyadmin (tool probably provided by your hoster) and change the collation on all tables to be the same. Hello This didnt work....I still have error when i try to perform search using Greek words Please any help is valuble Thanks
MrPhil Posted January 27, 2010 Posted January 27, 2010 The error message is telling you that parts (or all) of your database are the default Latin-1 (ISO-8859-1) encoding and collation, while other parts may be Greek (ISO-8859-7?). The entire database might still be Latin-1, which MySQL isn't going to like to mix with Greek text coming in. You will need to ensure that your database is ISO-8859-7, but I don't know if you can directly do that (either through osC or phpMyAdmin) without also translating the existing tables. Presumably the database already contains Greek text, so you don't want to "translate" it to Greek -- that would mess up the data. At worst, someone will have to instruct you on how to export (back up) all your data to a dump file, empty out the tables, change their encoding/collation to be consistently Greek, and import the data back in to restore the database. If you're lucky, you might be able to change the encoding/collation without changing the data itself. Someone better versed in MySQL will have to lead you through that. Are your Greek language support files in ISO-8859-7 too, not UTF-8? At any rate, before doing any operations on your database (such as changing encoding/collation), make a database backup. Worst case, you'll have to restore your database to get back to where you are now.
spooks Posted January 27, 2010 Posted January 27, 2010 Hello This didnt work....I still have error when i try to perform search using Greek words Please any help is valuble Thanks what version of MySQL ? have you raised it with your host? Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al.
gegeor Posted January 27, 2010 Author Posted January 27, 2010 Thanks for your replies MrPhil:I use ISO-8859-7 for Greek language files and the problem appeared with PHP upgradeto ver. 5. My host tried several times to find a solution but with no sucess.. The problem is at Mysql because i tried clean oscommerce installation ,import dbase and same thing happens...same error after the import The dbase has lot of items and in any case i cant just forget it..... spooks: MySQL client version: 5.0.87 and as i wrote up my host has tried to solved it ..Do you have any idea of what i ask my host specific to do?perhaps something they dont know? Many thanks both of you:)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.