mysqldump default-character-set does not affect on enum character set

Asked Jan 26 '15 at 12:00

Active Jan 28 '15 at 12:01

Viewed 299 times

I have a table that its default character set is latin1 but it contains the utf-8 values as rows. I have a enum column in this table that contains utf-8 as its items. While dumping by setting --default-character-set='latin1' its data correctly converted and are readable but enum values in definition does not convert and they are not readable:

enter image description here

MySQL version: 5.1

OS: RHEL 6.3

I can't alter table, It's in progress.

Any solution?

edited Jan 26 '15 at 17:51

asked Jan 26 '15 at 12:00

Farhadix

1,395
2
12
25

please read thread http://stackoverflow.com/questions/17049903/converting-mysql-table-with-incorrectly-encoded-data-to-utf-8 it might help .. – nirajkumar Jan 28 '15 at 12:10
I am not talking about data, I mean the values of definition an enum column. – Farhadix Jan 28 '15 at 13:10
How do you dump the db? – Phate01 Feb 04 '15 at 08:32
@Phate01 mysqldump --default-char-set=utf8 --opt -uroot -p dbname tablename > dump.sql – Farhadix Feb 04 '15 at 10:17
default-character-set – Farhadix Feb 04 '15 at 10:29

mysqldump default-character-set does not affect on enum character set

0 Answers0