Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

A rather strange request has appeared from our client, who wants to be able to search a SharePoint 2010 list for items (based on a string column) while ignoring diacritics.

A quick example, assuming this is a list with IDs and two columns:

1. Paweł | Marciniak

2. Pawel | Jankowski

then searching the first column for PAWEL (or PAWEŁ for that matter) should return both items.

Can it be done using CAML?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

AFAIK it's not possible using CAML alone.

But you may create an extra hidden column FirstNameNormalized, and update that with an EventReceiver on ItemAdded/ItemUpdated using a nomalized string like the one from Stripping is an interesting job.

Then when you're filtering you can do that on FirstNameNormalized using a likewise normalized string.

share|improve this answer
    
That was my initial idea, but I was hoping there was some way of making CAML do the work for me. Thanks for the answer. –  Shaamaan Oct 22 '12 at 7:20
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.