zdavatz Posted July 29, 2008 Share Posted July 29, 2008 Ok, I am doing this for several days now: 1. My MySQL DB - and all tables - are in utf8_general_ci 2. My OsCommerce installation is all UTF-8. My Kanji, Hiragana, Katakana and Umlaute (öäü) are all displayed correctly (also in the Email and Email-Subject, both HTML and Text). 3. When I search for Product Names containing Umlaute in the Frontend either using QuickSearch or Advanced Search no product names that use Umlaute are found. If I search in the Admin (i.e. in the Categories) then all the products containing Umlaute in the product names are found! So for the Admin everything works perfectly. Note: I also search in the description and I also tried REGEXP according to oschellas. I believe this is really an encoding problem. 4. For the frontend of OsCommerce my SQL outputs, "strange characters" when I search for Product Names containing Umlaute: select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%�' or a.actors_name % '�%' or p.products_model like '%�%' or m.manufacturers_name like '%�%' or pd.products_description like '%�%') ) Somehow what I enter into the Search Form either QuickSearch oder AdvancedSearch in the frontend does not get passed on in the correct manner! In the Admin section it works. Any Feedback is welcome. Best Zeno PS: If you need my ServerInfo let me know. I will send it to you. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.