This could help French users or any language with accents like é, à, ï, etc.
How to do this : in [Nop_ProductLoadAllPaged] store procedure, add you collation in ALL patindex function calls
Exemple : patindex(@Keywords, isnull(p.name, ''))
becomes : patindex(@Keywords, isnull(p.name, '') COLLATE French_CI_AI)
How does it work : changing sql collation 'on the fly' is just a way to temporary change rules for string comparison.
You only have to choose which rules you need for search function.
My example uses French_CI_AI, that means French, Case Insensitive, Accent Insensitive