sql - mysql charater set encoding in older version -

sql - mysql charater set encoding in older version -

i trying run query on old mysql database version 4.x.xx as

select "something" outfile '/var/migration/xxx.tsv' character set utf8 fields enclosed '"' terminated '\t' escaped '"' lines terminated '\r\n';

but think utf8 encoding not supported. can suggest way in can run query , info in utf8 encoding.

according mysql 4.1 documentation utf8 supported. seek this.

mysql_query("set names 'utf8'"); $sql = 'select `something` outfile '/var/migration/xxx.tsv' fields enclosed '"' terminated '\t' escaped '"' lines terminated '\r\n''; mysql_query($sql);

mysql sql