I have a custom field in my vendors that is a multiple picklist.

 

All works fine within ZOHO.  However the data stored in the custom field is not the correctly formatted text.

 

To explain.

I have a customModule with a field "Location Name"

Location Name contains the following correctly encoded charset text: 

"Chambéry Airport"

When I pick the same name from my Custom filed lookup in the Vendor Record the data is held as

"Chambery Airport" not  "Chambéry Airport"

Hence whenever I do any function calls in deluge using Location Name as a search String (or contains) it does not correctly find the record as they of course do not match?

 

Any ideas how I would get round this?  

it would be fine if in the deluge script I can convert the correctly formatted Name i.e. "Chambéry Airport"

 to "Chambery Airport" but I cannot see how as there appears to be no means of Charset conversation?

Alternatively is there a way to obtain the lookup"ID" in the pick list on my Vendors field instead of just using the name.  However again I have not seen any method for doing this?

Any help greatly appreciated.

Thanks