Hi

is possible to create FULLTEXT index on column which is varchar(100)
binary ???

trying this i got:
"ERROR 1005: Can't create table './xxx/#sql-19b_444.frm' (errno: 140)"

i need column which can be fulltext searchable and case-sensitive
(therefore column is binary)

i alter column to normal (deleted binary) and fulltext index created,
but i try search 'challenge' and got columnt which contains
'Challenge' and that's wrong for my application.


---
 Dvořáček Michal                         mailto:[EMAIL PROTECTED]



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to