UTF-8, OsCommerce, SQL, MySQL, wrong SQL encoding

[zdavatz]

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.

[spooks]

http://www.oscommerce.com/forums/index.php?sho...p;#entry1283177

[zdavatz]

Sorry, but did you read my post?

 

1. My products all have categories.

 

2. I already tripped over that one in my Admin section. I would not find my Product in my Admin-Section if I would not have put it into a category. If you read my post you would have seen, that I find my products with Umlaute in my Admin section.

 

3. I also get prefect search results for Products that do not contain "Umlaute" in their names.

 

4. My Search works perfectly. It just does not work for product names containing Umlaute.

 

So next solution please.

 

Best

Zeno

[zdavatz]

Ok, you where right. It was something with my categories. I apologize to you! I am very stupid. I somehow screwed up with EasyPopulate and that created to many unknown categories for me.

 

Best

Zeno