How to handle the colon character within fulltext search?

[Gary Long]

Hello there :)

I'm using the fulltext search feature of Jackrabbit and i'm facing a 
little problem with the colon character (:). For example, if I search 
for a mail which subject is "Tr : Tr : your response", I can't find it. 
If I search for "your response" the e-mail is found.

my sql query is :

SELECT * FROM mnt:resource WHERE (contains(jcr:text, '*tr: tr: your 
response*') OR contains(jcr:name, '*tr: tr: your response*');

Thank you for your help :)

Gary Long