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
> 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
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
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
