Re: fulltext search with utf8 characters (umlaut) with 5.1

[david halter]

Actually I found a pretty good way:

I used the convert() command.
Since this commands are not really working the way I want them to, I had a little time until I noticed how the convert() works properly.

You just need to use:
update test set fileNew = binary convert(file using latin1)


You can control the whole thing using:
select * from test where file != convert(convert((binary fileNew) using latin1) using utf8) limit 1;


Cheers!
David