Ldap search with parentheses in the search input

What we encountered today involves the usage of open / close parentheses which are wrapped around the area code.

The error received is ---
Filter Error
LDAPLocalException: The invalid character "(" needs to be escaped as "\28" (87) Filter Error

What is the correct way to format a text search for a phone number that begins (794)?

Thank you in advance for your time and assistance

Open and close parentheses needed to be escaped with \28 and \29, respectively. To query homePhone (771) 877-1910 please format the query such as:

(homePhone=\28771\29877-1910)

and with SQL:

select * from ou=People,dc=test,dc=com where homePhone= '\28771\29877-1910'

Thanks
LDAPSoft Support

One other question of a related manner. Do you have a listing/link of the escape codes and the values they represent that you would send us?

Thank you.

You may have to look a the LDAP specifications to find out the escape code.

Here is the link to the specification, search for parenthesis and look at the example for equivalent codes for start and end parenthesis.

(o=Parens R Us \28for all your parenthetical needs\29)

http://tools.ietf.org/html/rfc4515

Thanks
Support