Search without taking into account accent

Posts   
 
    
sybjeb
User
Posts: 81
Joined: 20-Sep-2011
# Posted on: 25-Oct-2013 15:12:51   

I'm using MySQL and LLBLGEN version 3.5 Final (November 6th, 2012).

Actually, when I search for a customer, if this customer has an accent in its name, this customer isn't found. To be able to find it, in SQL, I can use the collate function. So,

SELECT *
FROM customer
WHERE name LIKE 'RÖS%' collate utf8_general_ci

will return the 'ROTNER' customer but also the 'RÖSNER' customer.

How can I do it in Linq?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 26-Oct-2013 06:42:15   

You can collate the expression if you use DBFuncionCalls with constant. The following thread is an example for case-insensitive, but it's similar: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12216&StartAtMessage=0&#67837

David Elizondo | LLBLGen Support Team
sybjeb
User
Posts: 81
Joined: 20-Sep-2011
# Posted on: 29-Oct-2013 09:20:22   

OK thanks