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