我目前正在尝试在旧的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 'rn';
但我认为不支持UTF8编码。有人能建议我运行这个查询并以utf8编码获取数据的方式吗。
根据MYSQL 4.1文档,支持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 'rn'';
mysql_query($sql);