BLOB not storing utf-8 (Chinese) in MySQL
<p>I have a table like this</p>

<pre><code>CREATE TABLE account_data (
    id BIGINT NOT NULL,
    data BLOB NOT NULL,
    PRIMARY KEY (account_id)
)  ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
</code></pre>

<p>However MySQL is not storing it as Chinese, but some garbage values
like «å«¢ å æææ æ­¶ç·è
I checked everywhere and it says CHARSET must be utf8, which is my case
The MySql version I am using is 5.6.14.</p>

<p>I Tried </p>

<pre><code>ALTER TABLE account_data MODIFY data BLOB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
</code></pre>

<p>but for some reason, MySQL is giving syntax error for BLOB.</p>

<p>If I do </p>

<pre><code>insert into account_data (id
            ,data)
        VALUES
            (5952638508182497,

"123456偟 滭滹漇 嶕憱撏 齞齝囃 熤熡"

            );
</code></pre>

<p>and check TEXT in Viewer in MySQL workbench, I can see 123456 but for Chinese I am seeing garbage.</p>

<p>Thanks</p>