<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[运维进行时]]></title> 
<link>https://blog.liuts.com/index.php</link> 
<description><![CDATA[互联网运维与架构]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[运维进行时]]></copyright>
<item>
<link>https://blog.liuts.com/post//</link>
<title><![CDATA[Mysql字段长度自动变短了:(]]></title> 
<author>root &lt;admin@yourname.com&gt;</author>
<category><![CDATA[MYSQL]]></category>
<pubDate>Thu, 22 May 2008 13:11:45 +0000</pubDate> 
<guid>https://blog.liuts.com/post//</guid> 
<description>
<![CDATA[ 
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;原服务器Mysql用的编码是latin1，结果更新了服务器，数据需要备份过来，新服务器数据库安装的时候选择了gbk编码，结果发现char、varchar类型的字段长度都有不同程度的变短。更换编码试试，先换成utf-8，结果还是一样。最后想想还是用原服务器数据库的编码，在my.cnf修改的[client]及[mysqld]处添加default-character-set=latin1，重启Mysql，数据恢复正常<br/>Tags - <a href="https://blog.liuts.com/tags/%25E5%258F%2598%25E7%259F%25AD/" rel="tag">变短</a>
]]>
</description>
</item><item>
<link>https://blog.liuts.com/post//#blogcomment</link>
<title><![CDATA[[评论] Mysql字段长度自动变短了:(]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>https://blog.liuts.com/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>