将中文存入 latin1 字符集的表,可以恢复吗?
>create table latin1(id int auto_increment primary key, data varchar(128)) charset=latin1;
>set character_set_connection=latin1;
>set character_set_client=latin1;
>insert into latin1(data) values('中文abc123!@#')
>select * from latin1;
+----+--------------------------------------------+
| id | data |
+----+--------------------------------------------+
| 1 | ä¸æ–‡123abc!@# |
+----+--------------------------------------------+
现在还可以恢复么?如果可以,怎么恢复?
推荐文章: