CODEWITHSUNDEEP
phpmysqlsphinx
JezB
JezB

Reputation: 528

Sphinx/MySQL UTF8 & ™ symbol

We use Sphinx for a site search, but I'm very new to it.

It doesn't like the ™ symbol (™) - in the results I just get the question-mark-in-a-diamond symbol.

I have set the following, but no difference.

    sql_query_pre   = SET NAMES utf8
    sql_query_pre   = SET CHARACTER_SET_RESULTS=utf8

Any ideas?

Upvotes: 0

Views: 224

Answers (1)

Itay Elkouby
Itay Elkouby

Reputation: 355

I'm not familiar with Sphinx But try use utf8mb4_unicode_ci for the table encoding..

INSERT INTO testT (`fieldA`) VALUES ("™");
SELECT * FROM testT;

Seems to show a fine results

Upvotes: 1

Related Questions