Search code examples
full-text-searchssrs-2008

Full text query parameter for full text query string is not valid with ssrs

I am using Full Text Search in a table-valued function. The function is created on SQL Server 2008. The function works perfect in SQL, however on SSRS I get this error:

Full text query parameter for full text query string is not valid with ssrs

the parameter @Search is of varchar(64).

Any idea what may fix this error?

Solution

  • I changed the @Search parameter in my function to be nvarchar(255) and problem solved!