Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

fulltext search using different collation

Status
Not open for further replies.

tdolfo

Programmer
Jul 9, 2007
2
US
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;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top