Hello all,
I'm running MySQL 5.0.41. I have a table with its charset set to utf8,
collated to utf8_bin. I'm using utf8_bin because I need case-sensitive
unique values in a specific column. I'd like to perform a case-
insensitive fulltext search on this particular column. I've created a
fulltext key, however I cannot seem to change the collation for the
search. I see no docs on the MySQL website either (however I did find
this, which may be useful to some: Ultimately, I need inserts to be case-sensitive for uniqueness, but
fulltext searches to be case-insensitive. I've included my test table
creation statement. Any help would be appreciated.
Thanks,
TD
CREATE TABLE TestTable
(
ID int NOT NULL auto_increment,
Chars varchar(100) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (Chars),
FULLTEXT (Chars)
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_bin;
I'm running MySQL 5.0.41. I have a table with its charset set to utf8,
collated to utf8_bin. I'm using utf8_bin because I need case-sensitive
unique values in a specific column. I'd like to perform a case-
insensitive fulltext search on this particular column. I've created a
fulltext key, however I cannot seem to change the collation for the
search. I see no docs on the MySQL website either (however I did find
this, which may be useful to some: Ultimately, I need inserts to be case-sensitive for uniqueness, but
fulltext searches to be case-insensitive. I've included my test table
creation statement. Any help would be appreciated.
Thanks,
TD
CREATE TABLE TestTable
(
ID int NOT NULL auto_increment,
Chars varchar(100) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (Chars),
FULLTEXT (Chars)
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_bin;