Full-text search and queries sensitive to accents

2008-09-26 Thread Fco. Mario Barcala
Hi all: I read in mysql documentation that searches are case-insensitive by default but this default behaviour can be changed using a latin1_bin collation. But, is there any way to make searches sensitive or unsensitive to accents, umlauts, etc.? I suppose that queries are accent sensitive by

50% full text threshold

2008-09-12 Thread Fco. Mario Barcala
Hi all: I have been reading mysql 5.1 documentation and it says that default 50% threshold for natural language searches can be changed in storage/myisam/ftdefs.h but, what I have to change to allow indexing of all words? This percentage is not explicit in the file, so I don't know what I have

Full text search and highlight results

2008-09-08 Thread Fco. Mario Barcala
Hi all: I was reading documentation and searching into mail archives but I didn't find a solution to the following question: Is there any way to highligh results from a full-text search? I know some tricky methods using PHP but I want to know if mysql (5.0 or 5.1 versions) offers some methos or