MySQL Forums
Forum List  »  Full-Text Search

Re: fulltext search with utf8 characters (umlaut) with 5.1
Posted by: david halter
Date: September 26, 2010 02:03PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: fulltext search with utf8 characters (umlaut) with 5.1
3726
September 26, 2010 02:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.