INTO OUTFILE 怎么指定输出文件的编码方式？生成的文件编码格式不确定？？？

Question

用格式同样的语句从数据库中生成文件，可是生成的文件编码不确定，用notepad++打开看，有的是ANSI，有的就是UTF8，这怎么能解决啊？我想要utf8的文件输出……SELECT time INTO OUTFILE ‘abc.dat’ FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\\\"' LINES TERMINATED BY '\\n' FROM table_log_telnet

Answer 1

检查一下你的字符集设置。mysql> show variables like 'char%';
+--------------------------+--------------+
| Variable_name            | Value     |
+--------------------------+--------------+
| character_set_client     | utf8     |
| character_set_connection | utf8     |
| character_set_database   | latin1     |

Answer 2

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
就这样的设置，有的出来文件是utf8的，有的不是，怎么解决？