MySQL Forums
Forum List  »  Full-Text Search

Re: fulltext search with utf8 characters (umlaut) with 5.1
Posted by: Rick James
Date: September 23, 2010 09:11AM

SELECT id, HEX(name) FROM fulltexttable;

Do you get this?
1 62C383C2A47274736368
  b ^ ^ ^ ^ r y s c h
That would be the dreaded "double encoding".

Drop the table, and repeat, doing
SET NAMES utf8
after the connect and before the rest of the code.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: fulltext search with utf8 characters (umlaut) with 5.1
3487
September 23, 2010 09:11AM


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.