mysql 数据库存储图片与字符串组合的字段 ------moji图标存储

首先更改mysql的数据编码，修改mysql的配置文件：  /etc/mysql/my.cnf 添加：

1. [client]  
2. default-character-set = utf8mb4  
3.   
4. [mysql]  
5. default-character-set = utf8mb4  
6.   
7. [mysqld]  
8. character-set-client-handshake = FALSE  
9. character-set-server = utf8mb4  
10. collation-server = utf8mb4_unicode_ci  

重启mysql：输入命令 

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

1. --------------------------+----------------------------+  
2. | Variable_name            | Value                      |  
3. +--------------------------+----------------------------+  
4. | character_set_client     | utf8mb4                    |  
5. | character_set_connection | utf8mb4                    |  
6. | character_set_database   | utf8mb4                    |  
7. | character_set_filesystem | binary                     |  
8. | character_set_results    | utf8mb4                    |  
9. | character_set_server     | utf8mb4                    |  
10. | character_set_system     | utf8                       |  
11. | character_sets_dir       | /usr/share/mysql/charsets/ |  
12. | collation_connection     | utf8mb4_unicode_ci         |  
13. | collation_database       | utf8mb4_unicode_ci         |  
14. | collation_server         | utf8mb4_unicode_ci         |  
15. +--------------------------+----------------------------+

第一步：给数据库,数据表，字段添加    utf8mb4编码

地址来源：http://zhidao.baidu.com/question/264009281026565765.html?fr=iks&word=mysql+%C3%FB%D7%D6%B4%F8moji%CD%BC%C6%AC%2C%D4%F5%C3%B4%B4%E6%B5%BDmysql%C0%EF%2C%D7%D6%B7%FB%B1%E0%C2%EB&ie=gbk