SQL & PL/SQL

Hi,

I am trying to query a table using the contains function. The below piece of code fails:

AND CONTAINS(column_1, 'octogénaires') > 0

while the below works fine:

AND column_1 LIKE '%octogénaires%'

Please would someone be able to help with what is the problem here.