Author Topic: Illegal mix of collations on search in shop  (Read 184 times)

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3980
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Illegal mix of collations on search in shop
« on: June 06, 2019, 22:46:07 pm »
r
Code: [Select]
`l`.product_name LIKE "%poli�r%" OR `p`.product_sku LIKE "%poli�r%" OR `l`.product_s_desc LIKE "%poli�r%" OR `l`.product_desc LIKE "%poli�r%" OR `category_name` LIKE "%poli�r%" OR `category_description` LIKE "%poli�r%" OR `p`.product_special LIKE "%poli�r%") [[code]https://demo.virtuemart.net/?keyword=poli%car&view=category&option=com_virtuemart&virtuemart_category_id=0&Itemid=121[/code]

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3980
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: Illegal mix of collations on search in shop
« Reply #1 on: June 06, 2019, 22:54:25 pm »
Hum response bugs in posting too
The problem is for eg keyword=poli%car in the URL