Simple question... I have a service which returns the users and I implemented a FilterDescriptor which calls that service to populate a grid.
The filterdescriptor has the Contains
oper开发者_如何学Cator and it works fine as far as the user's first or last name does not have accents.
If I want to search for the 'Gómez' is my table, I want to be able to just type 'gomez', but that it's not working.
Is there a property or something I'm missing? How can I achieve that?
This question helped me out... Ignoring accents in SQL Server using LINQ to SQL
ALTER TABLE IDBUsers ALTER COLUMN LastName nvarchar(256) COLLATE SQL_Latin1_General_CP1_CI_AI
精彩评论