mysql图片乱码

Question

mysql> use hst_rsgz1
Database changed
mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------+| Variable_name            | Value                                             |+--------------------------+---------------------------------------------------+| character_set_client     | utf8                                              || character_set_connection | utf8                                              || character_set_database   | utf8                                              || character_set_filesystem | binary                                            || character_set_results    | utf8                                              || character_set_server     | utf8                                              || character_set_system     | utf8                                              |
| character_sets_dir       | C:\Program Files\MySQL Server 5.0\share\charsets\ |+--------------------------+---------------------------------------------------+8 rows in set (0.00 sec)用mysqldump导出图片来全是乱码，但用Navicat for MySQL导出来的不是乱码，
我要mysqldump导出来的不是乱码，怎么做？

Answer 1

--hex-blob
 
使用十六进制格式导出二进制字符串字段。如果有二进制数据就必须使用本选项。影响到的字段类型有 BINARY、VARBINARY、BLOB。