My ft configuration in /etc/my.conf:
------
ft_min_word_len=1
ft_stopword_file=''
-----
On 9/21/07, thomas Armstrong <[EMAIL PROTECTED]> wrote:
> Hi.
>
> Using mySQL 4.1.22, I'd like to carry out an SQL query to find a
> string containing acute vowels.
>
> mytable:
> - item1:
> --- firstname: Antonio
> --- lastname: Fernández
> --- comments: he's from Spain
>
> My SQL query:
> ------
> SELECT id FROM mytable WHERE MATCH(firstname, lastname, comments)
> AGAINST ('+"fernandez"' IN BOOLEAN MODE) ORDER BY firstname, lastname
> --------
>
> If mytable is in latin1, it works fine. But if mytable is in utf8
> (it's the case) it doesn't work. How can I change my SQL query to
> match 'Fernández' in UTF8 within the table?
>
> Thank you very much.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
