KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
How can I ignore accents (like ยด, `, ~) in queries made to a SQL Server database using LINQ to SQL? UPDATE: Still haven't figured out how to do it in LINQ (or even if it's possible) but I managed to change the database to solve this issue. Just had to change the collation on the fields I wanted to search on. The collation I had was: SQL_Latin1_General_CP1_CI_AS The CI stans for "Case Insensitive" and AS for "Accent Sensitive". Just had to change the AS to AI to make it "Accent Insensitive". The SQL statement is this: ALTER TABLE table_name ALTER COLUMN column_name column_type COLLATE collation_type
Tags (comma-separated)
Save Edits
Cancel