fulltext

[n_gatsis]

Why cant I make a field -which is binary- fulltext(ed). I'm using 3,23 release for linux.

The reason i use binary field is that in greek language the sorting is not right without it.
Thank you.

[Anon]

How can i connect to a mssql server on windows?

[okyejr]

what's the error messages?

[Anon]

First make sure the column(s) are of type varchar or text. If not then you need to alter the table and change them to one of those data types (eg. ALTER TABLE table_name MODIFY column_name varchar NOT NULL). Then type this query...

ALTER TABLE table_name ADD FULLTEXT (column_name)

... Of coarse you should replace table_name with the name of your table and column_name with the name of the column that you want to have indexed.

[n_gatsis]

I've allredy do this. But, if the column is declared as binary mysql can't accept fulltext it.
Anything about that?
Thanks a lot