旧版本中的mysql字符集编码

Question

我当前正在尝试在旧的mysql数据库版本4.x.xx上运行查询，如下所示

select "something"
INTO OUTFILE '/var/migration/xxx.tsv'
CHARACTER SET utf8
FIELDS ENCLOSED BY '"' TERMINATED BY '\t' ESCAPED BY '"'
LINES TERMINATED BY '\r\n';

但我认为不支持UTF8编码。有没有人能建议我如何运行这个查询并获得utf8编码的数据。

Answer 1

根据MYSQL 4.1 documentation，支持UTF8。尝尝这个。

mysql_query("set names 'utf8'");
$sql = 'SELECT `something`
        INTO OUTFILE '/var/migration/xxx.tsv'
        FIELDS ENCLOSED BY '"' TERMINATED BY '\t' ESCAPED BY '"'
        LINES TERMINATED BY '\r\n'';
mysql_query($sql);