re: Mysqldump problem in output UTF-8 Char

2004-02-21 Thread Jeremy March
> in which table i set to use Charset (UTF-8). > But When i use "mysql>mysqldump -u myname -p mypwd telbook>book.txt", all > string of table friend's c_name will become "?". Have you tried: mysqldump --default-character-set=utf8 -u myname -p mypwd telbook>book.txt If that doesn't work, which

Mysqldump problem in output UTF-8 Char

2004-02-21 Thread SZE LEUNG CHAN
I have a table create table friend( f_code int(7) not null AUTO_INCREMENT, c_name varchar(20), //Use to store Chinese Name e_name varchar(50) //use to store English Name ); in which table i set to use Charset (UTF-8). But When i use "mysql>mysqldump -u myname -p mypwd telbook>book.txt", all strin