Sybase Error – Text index with external prefilter cannot contain both binary and string columns

In this blog post, you’ll learn more about the Sybase Error Text index with external prefilter cannot contain both binary and string columns and the reason for receiving this error

Sybase SQL Error Message

Text index with external prefilter cannot contain both binary and string columns

Reason for this Error

One or more, but not all, of the columns specified for the text index is of type binary, and the text configuration object has a prefilter library specified. Text indexes using a prefilter library can contain either binary columns or string data type columns, but not both.