On 17 Jul 2003 at 23:03, Yves Goergen wrote: > > >2. What about fulltext search on UTF8 strings? > > > > Unavailable. > > Eh? Why should this be a special DB feature at all? > Correct me if I'm wrong (I didn't have very much contect with > fulltexts yet), but can't I just give mysql an UTF8 string to search > in an UTF8 column (/data)? Shouldn't this work anyway? (Even if I put > UTF8 data in mysql 3.23 by now and just search this?)
FULLTEXT indexes are constructed by dividing the text up into "words", which requires that MySQL handle the particular character encoding and character set so as to know which characters (or byte sequences) are parts of words and which aren't. Perhaps you're think of the LIKE operator? -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
