Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Jared Evans (Guest)
Jared Evans (Guest)
The product search on Viart should be case insensitive.
 
The 6 LIKEs starting on line 216 in the file 'block_products_list.php' should be changed to ILIKEs.
 
This tip is for Viart Enterprise 2.8 using PostgreSQL database
 
 
Last modified: 6 Dec 2006 11:03 AM
 
Eugene (Guest)
Eugene (Guest)
Hi,
 
LIKE comparison is case insensitive in MySQL and MS Access and case sensitive in Postgre.
Perhaps in some release we shall change search queries to case insensitive mode.
 
The product search on Viart should be case insensitive.
 
The 6 LIKEs starting on line 216 in the file 'block_products_list.php' should be changed to ILIKEs.
 
This tip is for Viart Enterprise 2.8 using PostgreSQL database
 
 
WBR,
Eugene
ViArt Support Team