Re: How to match a UTF-8 field with acute vowels words in "BOOLEAN MODE"?

2007-09-21 Thread thomas Armstrong
Hi Edward. Thank you very much for your answer. I tried adding these two lines after DB connection (PHP code): --- mysql_query ("SET NAMES utf8;"); mysql_query ("SET CHARACTER_SET utf8;"); -- but it won't work :( The solution you provided could be right because it works, but I don't dare

RE: How to match a UTF-8 field with acute vowels words in "BOOLEAN MODE"?

2007-09-21 Thread Edward Kay
> 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, lastnam

Re: How to match a UTF-8 field with acute vowels words in "BOOLEAN MODE"?

2007-09-21 Thread thomas Armstrong
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: Anto

Re: How to match a UTF-8 field with acute vowels words in "BOOLEAN MODE"?

2007-09-21 Thread mysql
Apart from the character-set, did you check your collation-sequences? SHOW GLOBAL VARIABLES like "collation%"; collation sequences can be set on the server-level, database-level, table-level... suomi thomas Armstrong wrote: Hi. Using mySQL 4.1.22, I'd like to carry out an SQL query to find