插入大文本内容竟然不全

[tan625747]

sql语句是：

insert into food(Content,title,url) values('<div class="entry">
<div class="minfo" style="padding:0;">
<div class="person"><a href="space-487845.html" title="JN楂橀€? target="_blank"><img src="http://i3.meishichina.com/data/avatar/000/48/78/45_avatar_small.jpg" alt="JN楂橀€? width="48" height="48" border="0" /></a></div>
<div class="detail">
<h1><a href="recipe-53809.html" title="鐚倝鐐搁叡闈? class="arTitle">鐚倝鐐搁叡闈?/a></h1>
<div class="arinfo"><span><iframe width="120" height="24" frameborder="0" allowtransparency="true" marginwidth="0" marginheight="0" scrolling="no" border="0" src="http://widget.weibo.com/relationship/followbutton.php?language=zh_cn&width=136&height=24&uid=1642625033&style=2&btn=light&dpc=1"></iframe></span><span><iframe src="http://open.qzone.qq.com/like?url=http%3A%2F%2Fuser.qzone.qq.com%2F1426269787&type=button_num&width=120&height=22" allowtransparency="true" scrolling="no" border="0" frameborder="0" style="width:120px;height:22px;border:none;overflow:hidden;"></iframe></span><a href="space-487845.html" title="JN楂橀€? target="_blank">JN楂橀€?/a> 鍙戣〃浜?012-03-10 17:18</div>
</div>
</div>
<div class="m8info">
<div class="pic">
            	                	<img class="pngimg" src="http://static.meishichina.com/u2/v3/image/shoufa.png" style=" position:absolute"/>
                <a href="recipe-53809-do-photo-photoid-90643.html"><img src="http://i3.meishichina.com/attachment/recipe/2012/03/10/p_20120310170449403482740.jpg" alt="鐚倝鐐搁叡闈? width="280" border="0" /></a>
<ul id="photolist">
</ul>
</div>
            
<div class="detail">

<div class="uarea">

<div class="ualeft">
<ul>
<li>鑿滃搧鍙ｅ懗锛?a href="recipe-type-do-cuisine-view-8.html" target="_blank">鍜搁矞</a></li>
<li>涓昏宸ヨ壓锛?a href="recipe-type-do-technics-view-7.html" target="_blank">鐓?/a></li>
<li>鎵€闇€鏃堕棿锛?a href="recipe-type-do-during-view-2.html" target="_blank">寤垮垎閽?/a></li>
<li>鍒朵綔闅惧害锛?a href="recipe-type-do-level-view-2.html" target="_blank">鏅€?/a></li>
<li>鎵€鐢ㄥ帹鍏凤細鐐掗攨 鐓攨 </li></ul>
</div>
<div class="uaright">
<dl>
<dt class="s5" title="寰堟"></dt><dd>3</dd>
<dt class="s4" title="杈冨ソ"></dt><dd>1</dd>
<dt class="s3" title="杩樿"></dt><dd>1</dd>
<dt class="s2" title="杈冨樊"></dt><dd>0</dd>
<dt class="s1" title="寰堝樊"></dt><dd>0</dd>
</dl>
<p>(<a href="recipe-53809-do-collection.html">5浜鸿瘎浠?/a>)</p>
                                                	</div>
</div>
<h4>椋熸潗鏄庣粏</h4>
                                	                    <div class="foodlist">
                        <ul>
                            <li style="float:left;width:50%;padding-right:0px"><b><a href="search.php?q=%E7%8C%AA%E8%82%89%E9%A6%85&type=ingredient&cs=utf8" title="鐚倝棣呯殑鏇村鍋氭硶" target="_blank">鐚倝棣?/a></b> 250鍏?/li>
                            <li style="float:left;width:50%;padding-right:0px"><b><a href="search.php?q=%E6%89%8B%E6%93%80%E9%9D%A2&type=ingredient&cs=utf8" title="鎵嬫搥闈㈢殑鏇村鍋氭硶" target="_blank">鎵嬫搥闈?/a></b> 250鍏?/li>
                                                    </ul>
                    </div>
                                                            <div class="foodlist">
                        <ul>
                                                        <li style="float:left;width:50%;padding-right:0px" ><b>钁变即渚ｈ眴鐡ｉ叡</b> 1缇瑰寵</li>
                                                        <li style="float:left;width:50%;padding-right:0px" ><b>钁变即渚ｇ敎闈㈤叡</b> 1缇瑰寵</li>
                                                    </ul>
                    </div>
                                                            <div class="foodlist">
                        <ul>
                                                        <li style="float:left;width:50%;padding-right:0px"><b>鐢熸娊</b> 閫傞噺</li>
                                                        <li style="float:left;width:50%;padding-right:0px"><b>鐧界硸</b> 閫傞噺</li>
                                                        <li style="float:left;width:50%;padding-right:0px"><b>濮?/b> 閫傞噺</li>
                                                        <li style="float:left;width:50%;padding-right:0px"><b>钁?/b> 閫傞噺</li>
                                                        <li style="float:left;width:50%;padding-right:0px"><b>鑹叉媺娌?/b> 閫傞噺</li>
                                                    </ul>
                    </div>
                                    </div>
<div class="infob" style="position:relative;">鐚倝鐐搁叡闈㈡槸鏈€瀹跺父鐨勭偢閰遍潰涔嬩竴銆傛柟渚垮張缇庡懗锛屽湪鎴戝鐨勫嚭闀滅巼鏄尯楂樼殑銆傚挨鍏舵槸杩欎竴娆剧函鑲夌偢閰遍潰锛岀壒鍒彈瀛╁瓙鍜岃€佸叕鐨勬杩庯紝鍥犱负浠栦滑閮芥槸椋熻倝鍔ㄧ墿鍟娿€?/div></div>','猪肉炸酱面','http://home.meishichina.com/recipe-53809.html')

没想到content内容为：

<div class="entry">
 <div class="minfo" style="padding:0;">
 <div class="person"><a href="space-1846319.html" title="13683300407" target="_blank"><img src="http://i3.meishichina.com/data/avatar/001/84/63/19_avatar_small.jpg" alt="13683300407" width="48" height="48" border="0" /></a></div>
 <div class="detail">
 <h1><a href="recipe-53793.html" title="涓

只这么一点，该怎么半才好啊

[ACMAIN_CHM]

show create table food 贴出来分析一下。

[tan625747]

[Quote=引用 1 楼 的回复:]

show create table food 贴出来分析一下。
[/Quote]

CREATE TABLE `food` (
`idfood` int(11) NOT NULL AUTO_INCREMENT,
`Content` longtext CHARACTER SET gb2312,
`url` varchar(45) CHARACTER SET gb2312 DEFAULT NULL,
`title` varchar(45) CHARACTER SET gb2312 DEFAULT NULL,
PRIMARY KEY (`idfood`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

[tan625747]

顶啊，有人帮助我没呢

[tan625747]

[Quote=引用 4 楼 的回复:]

编码问题吧
[/Quote]

非常正确

[淼哥]

编码问题吧

[一起混吧]

`Content` longtext CHARACTER SET gbk, //改成这样试试。