برگزیده های پرشین تولز

ارور : String or binary data would be truncated

shervin

ASP.net
کاربر قدیمی پرشین تولز
تاریخ عضویت
26 ژوئن 2005
نوشته‌ها
6,353
لایک‌ها
261
سن
38
محل سکونت
تهران
کم مونده گریه کنم
2-3 روزه مشکلم حل نشده
دارم سعی میکنم متن html بریزم تو دیتا بیس
بعضی وقتا میریزه بعضی وقتا ارور میده
الان که همش ارور میده
ارور همین تیتر رو میده
بعد ورداشتم انواع و اقسام فیلد هارو با ماکزیمم سایز امتحان کردم نشد
باینری و ورچر و تکست و ...
بعضی وقتام یه ارور میده وقتی میزارم رو ورچر میگه نمیتونم ان تکست رو به ورچر تبدیل کنم
بعد تو کد میزنم اینو به صورت ورچر بفرست با ماکزیمم سایز باز ارور میده
واقعا نمیدونم چیکار کنم
یه مددی برسونید:wacko:
 

shervin

ASP.net
کاربر قدیمی پرشین تولز
تاریخ عضویت
26 ژوئن 2005
نوشته‌ها
6,353
لایک‌ها
261
سن
38
محل سکونت
تهران
سلام سالی
خوبی؟
آخه یکی دوتا نیست که میلیون ها صفحس که باید بریزم تو دیتا بیس واسه همین ناراحت حجم دیتا بیسم هستم
مثلا این متن ارور میده
<html>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<head>
<title>What Is a Beta?</title>
<link rel="STYLESHEET" type="text/css" href="images/style.css">
<link rel="STYLESHEET" type="text/css" href="images/docsafari.css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=ch01a.html><img src="images/prev.gif" width="60" height="17" border="0" align="absmiddle" alt="Previous Page"></a>
<td align="right"><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=ch01alev1sec2.html><img src="images/next.gif" width="60" height="17" border="0" align="absmiddle" alt="Next Page"></a>
</div></td></tr></table>
<br><table width="100%" border="0" cellspacing="0" cellpadding="0"><TR><TD valign="top"><a name="ch01alev1sec1"></a>
<h3 id="title-IDAGNJQG" class="docSection1Title">What Is a Beta?</h3>
<p class="docText">When software vendors work on a new or updated program, they perform extensive in-house testing of the new version. This is called <span class="docEmphasis">alpha testing</span>, and each new version of the software-in-progress is called an <span class="docEmphasis">alpha</span>.</p>
<p class="docText">A <span class="docEmphasis">beta</span>, a term you've probably heard used 3 or 4 or 20,000 times or so, is a later version of the prerelease program that the company distributes to outside users for testing and feedback. The process of third-party distribution, testing, and feedback is called a <span class="docEmphasis">beta test</span>, and the users who put the program through its paces are called <span class="docEmphasis">beta testers</span>.</p>
<a name="ch01anote01"></a><div class="docNote"><p class="docNoteTitle">Note</p>

<p class="docText">Because the alpha test is an &quot;in-house&quot; procedure, many a wag has dubbed the beta test an &quot;out-house&quot; procedure. Also, because software with even the most thoroughly tested alpha and beta versions behind it will still ship with more than a few bugs, other wags (or possibly the same ones) have taken to calling the released product the <span class="docEmphasis">gamma version.</span></p>
</div><br>
<p class="docText">The software industry has used the terms <span class="docEmphasis">alpha</span> and <span class="docEmphasis">beta</span> since the early 1980s, but they date back to the 1960s in the hardware world. In fact, the terms are thought to have originated at IBM in the early 1960s and come from that company's use of the terms <span class="docEmphasis">A-test</span> and <span class="docEmphasis">B-test</span> for the initial testing of new hardware components.</p>
<p class="docText">Microsoft first started beta-testing its software in the early 1980s, and almost all of its operating systems have run through a beta-testing cycle (the possible exception is the original version of MS-DOS). The old DOS beta cycles had perhaps a few hundred testers, but in recent years the Windows beta test brigade has mushroomed. The Whistler (Windows XP) beta test had a whopping half a million users, who combined to discover tens of thousands of bugs, big and small. The numbers in the Longhorn/Vista beta test have been even bigger. Although the first beta was distributed to just 10,000 users (but was also made available to a few hundred thousand Microsoft Developer Network and TechNet subscribers), it was estimated that up to 2 million people would take a crack at Beta 2, the first build made available to the general public.</p>
<p class="docText">What do Windows beta testers do? Those of us who take our beta-testing duties seriously end up doing quite a bit, actually. You have to install each beta, of course, which is no small feat in itself because you have to download a 3GB file, burn that file to a DVD, wipe everything from your test machine, run the setup program, and then tweak your device drivers, depending on the level of driver support in the beta you're installing. Then you need to fill out an installation survey and possibly a hardware survey. Then, most importantly, you need to use the operating system in various scenarios to see if everything works the way it should. If it doesn't, you need to submit a bug report to Microsoft. While you're doing this, you also need to read and participate in the beta newsgroups, follow or contribute to the periodic live chats with the developers, and try out the &quot;feature previews&quot; and report your results. Add to this the necessary (but not for the beta) tasks of studying Microsoft's whitepapers and briefing notes for all the new technologies, following the blogs related to the new OS, keeping tabs on the Microsoft &quot;rumor&quot; sites, and all the while writing up your findings in such a way that people such as yourself will know what to expect. It's hard but very satisfying work, and one of the more tangible results of it all is the book that you now hold in your hands.</p>
<a name="ch01anote02"></a><div class="docNote"><p class="docNoteTitle">Note</p>


<p class="docText">There's a popular and appealing tale of how the word <span class="docEmphasis">bug</span> came about. Apparently, an early computer pioneer named Grace Hopper was working on a machine called the Mark II in 1947. While investigating a glitch, she found a moth among the vacuum tubes, so from then on glitches were called bugs. Appealing, yes, but true? Not quite. In fact, engineers had already been referring to mechanical defects as &quot;bugs&quot; for at least 60 years before Ms. Hopper's discovery. As proof, the <span class="docEmphasis">Oxford English Dictionary</span> offers the following quotation from an 1889 edition of the <span class="docEmphasis">Pall Mall Gazette</span>:</p>
<p class="docText">&quot;Mr. Edison, I was informed, had been up the two previous nights discovering 'a bug' in his phonographan expression for solving a difficulty, and implying that some imaginary insect has secreted itself inside and is causing all the trouble.&quot;</P>
</div><br>

<a href="29021536.html"><img src="images/pixel.jpg" alt="" width="1" height="1" border="0"></a></TD></TR></table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=ch01a.html><img src="images/prev.gif" width="60" height="17" border="0" align="absmiddle" alt="Previous Page"></a>
<td align="right"><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=ch01alev1sec2.html><img src="images/next.gif" width="60" height="17" border="0" align="absmiddle" alt="Next Page"></a>
</div></td></tr></table>
</body></html>
ولی این متنو بدون ارور میریزه
<html>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<head>
<title>A</title>
<link rel="STYLESHEET" type="text/css" href="images/style.css">
<link rel="STYLESHEET" type="text/css" href="images/docsafari.css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=SYMBOL.html><img src="images/prev.gif" width="60" height="17" border="0" align="absmiddle" alt="Previous Page"></a>
<td align="right"><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=B.html><img src="images/next.gif" width="60" height="17" border="0" align="absmiddle" alt="Next Page"></a>
</div></td></tr></table>
<br><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td valign="top" class="v2"><br><h2 class="docGlossaryTitle">Index</h2><br>
[<a class="v1" href="SYMBOL.html">SYMBOL</a>]

[<a class="v1" href="A.html" style="font-weight:bold;">A</a>]

[<a class="v1" href="B.html">B</a>]

[<a class="v1" href="C.html">C</a>]

[<a class="v1" href="D.html">D</a>]

[<a class="v1" href="E.html">E</a>]

[<a class="v1" href="F.html">F</a>]

[<a class="v1" href="G.html">G</a>]

[<a class="v1" href="H.html">H</a>]

[<a class="v1" href="I.html">I</a>]

[<a class="v1" href="J.html">J</a>]

[<a class="v1" href="K.html">K</a>]

[<a class="v1" href="L.html">L</a>]

[<a class="v1" href="M.html">M</a>]

[<a class="v1" href="N.html">N</a>]

[<a class="v1" href="O.html">O</a>]

[<a class="v1" href="P.html">P</a>]

[<a class="v1" href="Q.html">Q</a>]

[<a class="v1" href="R.html">R</a>]

[<a class="v1" href="S.html">S</a>]

[<a class="v1" href="T.html">T</a>]

[<a class="v1" href="U.html">U</a>]

[<a class="v1" href="V.html">V</a>]

[<a class="v1" href="W.html">W</a>]

[<a class="v1" href="X.html">X</a>]

[<a class="v1" href="Y.html">Y</a>]
<br><br> <A class="v2" href="ch06lev1sec7.html#iddle2040"> <span class="docEmphStrong">ACL (access control lists)</span></A><br> <A class="v2" href="ch05lev1sec3.html#iddle1782"> <span class="docEmphStrong">Action pane (Event Viewer)</span></A><br> <A class="v2" href="ch06lev1sec7.html#iddle2057"> <span class="docEmphStrong">Activity Reports link (Parental Controls)</span></A><br> <A class="v2" href="ch08lev1sec1.html#iddle2289"> <span class="docEmphStrong">ad hoc wireless network connections</span></A><br> <A class="v2" href="ch08lev1sec3.html#iddle2336"> <span class="docEmphStrong">Add a Computer or Device link (Network Center)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1634"> <span class="docEmphStrong">Add a Label text box (Add Filter list)</span></A><br> <A class="v2" href="ch08lev1sec1.html#iddle2284"> <span class="docEmphStrong">Add a Network option (I Don't See the Networks I Am Looking For link)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1644"> <span class="docEmphStrong">Add Filter list (Advanced Filter pane)</span></A><br> <A class="v2" href="ch09lev1sec2.html#iddle2429"> <span class="docEmphStrong">Add Folder to Gallery command (WPG)</span></A><br> <A class="v2" href="ch09lev1sec6.html#iddle2687"> <span class="docEmphStrong">Add Pictures and Video to the DVD window (Windows DVD Maker)</span></A><br> <A class="v2" href="ch09lev1sec2.html#iddle2446"> <span class="docEmphStrong">Add Tags command (WPG)</span></A><br> <A class="v2" href="ch01lev1sec4.html#iddle1174"> <span class="docEmphStrong">add-ons (Internet Explorer 7), managing</span></A><A class="v2" href="ch06lev1sec5.html#iddle1966"> 2nd</A><br> <A class="v2" href="ch06lev1sec5.html#iddle1936"> <span class="docEmphStrong">Address bar (web pages), phishing</span></A><br> <A class="v2" href="ch06lev1sec5.html#iddle1922"> <span class="docEmphStrong">form-submittal addresses, phishing</span></A><br> <A class="v2" href="ch02lev1sec5.html#iddle1410"> <span class="docEmphStrong">Administrator accounts</span></A><A class="v2" href="ch06lev1sec6.html#iddle1982"> 2nd</A><br> <A class="v2" href="ch06lev1sec6.html#iddle1981"> <span class="docEmphStrong">administrator accounts</span></A><br> <A class="v2" href="ch06lev1sec6.html#iddle1983"> <span class="docEmphStrong">administrator groups</span></A><br> <A class="v2" href="ch06lev1sec4.html#iddle1905"> <span class="docEmphStrong">Administrator Settings section (Options page)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1615"> <span class="docEmphStrong">Advanced button (WSE)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1631"> <span class="docEmphStrong">Advanced Filter pane (Windows Search text box)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1616"> <span class="docEmphStrong">Advanced Options dialog</span></A><A class="v2" href="ch06lev1sec4.html#iddle1906"> 2nd</A><br> <A class="v2" href="ch04lev1sec2.html#iddle1632"> <span class="docEmphStrong">advanced searches</span></A><br> <A class="v2" href="ch07lev1sec5.html#iddle2224"> <span class="docEmphStrong">Advanced tab (Tablet PC Input Panel), Password Security option</span></A><br> <A class="v2" href="ch01lev1sec4.html#iddle1221"> <span class="docEmphStrong">Advanced Tag Editor (WMP 11)</span></A><A class="v2" href="ch09lev1sec3.html#iddle2554"> 2nd</A><br> <A class="v2" href="ch01lev1sec2.html#iddle1055"> <span class="docEmphStrong">Aero Glass theme</span></A><A class="v2" href="ch03lev1sec3.html#iddle1511"> 2nd</A><br> <A class="v2" href="ch01lev1sec4.html#iddle1198"> <span class="docEmphStrong">album art, WMP 11</span></A><A class="v2" href="ch09lev1sec3.html#iddle2501"> 2nd</A><br> <A class="v2" href="ch09lev1sec3.html#iddle2531"> <span class="docEmphStrong">Album view (WMP 11)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1633"> <span class="docEmphStrong">All Kinds option (Advanced Filter pane)</span></A><br> <A class="v2" href="ch03lev1sec2.html#iddle1502"> <span class="docEmphStrong">All Programs link (Start menu)</span></A><br> <A class="v2" href="ch06lev1sec4.html#iddle1903"> <span class="docEmphStrong">Allowed Items list (Windows Defender)</span></A><br> <A class="v2" href="ch06lev1sec7.html#iddle2074"> <span class="docEmphStrong">allowed/blocked website lists, importing to Parental Controls</span></A><br>
<A class="v2" href="ch03lev1sec3.html#iddle1513"> <span class="docEmphStrong">Alt+Tab cool switch</span></A> [See also <a class="docLink" href="F.html#iddle1516"><span class="docEmphStrong">Flip</span></a>.]<br> <A class="v2" href="ch04lev1sec2.html#iddle1648"> <span class="docEmphStrong">And Also option (Add Filter list)</span></A><br> <A class="v2" href="ch04lev1sec2.html#iddle1649"> <span class="docEmphStrong">And Either option (Add Filter list)</span></A><br> <A class="v2" href="ch07lev1sec5.html#iddle2225"> <span class="docEmphStrong">Angled scratch-out option (Gestures tab)</span></A><br> <A class="v2" href="ch03lev1sec1.html#iddle1480"> <span class="docEmphStrong">animations (WPF)</span></A><br><span class="docEmphStrong">AntiSpyware (MS)</span>
[See <a class="docLink" href="W.html#iddle1124"><span class="docEmphStrong">Windows Defender</span></a>.]<br> <A class="v2" href="ch08lev1sec3.html#iddle2320"> <span class="docEmphStrong">Anyone Who Is on the Same Network as This Computer option (File and Printer Sharing window)</span></A><br> <A class="v2" href="ch02lev1sec7a.html#iddle1367"> <span class="docEmphStrong">Anytime Upgrade</span></A><br> <A class="v2" href="ch01lev1sec5.html#iddle1294"> <span class="docEmphStrong">API</span></A><br> <A class="v2" href="ch02lev1sec7.html#iddle1415"> <span class="docEmphStrong">/append switch (XImage)</span></A><br> <A class="v2" href="ch05lev1sec3.html#iddle1787"> <span class="docEmphStrong">Application logs</span></A><A class="v2" href="ch05lev1sec3.html#iddle1809"> 2nd</A><br> <A class="v2" href="ch01lev1sec4.html#iddle1251"> <span class="docEmphStrong">application mixer (Volume window)</span></A><A class="v2" href="ch09lev1sec5.html#iddle2658"> 2nd</A><br> <A class="v2" href="ch05lev1sec3.html#iddle1795"> <span class="docEmphStrong">Application option (Global Logs pane)</span></A><br> <A class="v2" href="ch06lev1sec7.html#iddle2085"> <span class="docEmphStrong">Application Restrictions page (Parental Controls)</span></A><br> <A class="v2" href="ch01lev1sec4.html#iddle1199"> <span class="docEmphStrong">art (album), WMP 11</span></A><br> <A class="v2" href="ch09lev1sec3.html#iddle2502"> <span class="docEmphStrong">Artist view (WMP 11)</span></A><br><span class="docEmphStrong">as-you-type searches</span>
[See <a class="docLink" href="I.html#iddle1040"><span class="docEmphStrong">instant searches</span></a>.]<br> <A class="v2" href="ch05lev1sec3.html#iddle1804"> <span class="docEmphStrong">Attach Task to This Event option (Action pane)</span></A><br> <A class="v2" href="ch09lev1sec4.html#iddle2648"> <span class="docEmphStrong">audio (digital)</span></A><br>&nbsp;&nbsp;&nbsp;&nbsp; <A class="v2" href="ch09lev1sec5.html#iddle2669"> Audio Devices and Sound Themes icon (Control Panel)</A><br>&nbsp;&nbsp;&nbsp;&nbsp; <A class="v2" href="ch09lev1sec5.html#iddle2659"> per-application volume control</A><br>&nbsp;&nbsp;&nbsp;&nbsp; <A class="v2" href="ch09lev1sec5.html#iddle2670"> Sound Recorder</A><br>&nbsp;&nbsp;&nbsp;&nbsp; <A class="v2" href="ch09lev1sec5.html#iddle2660"> Volume Control tool</A><br>&nbsp;&nbsp;&nbsp;&nbsp; <A class="v2" href="ch09lev1sec5.html#iddle2661"> Volume window, application mixer</A><br> <A class="v2" href="ch09lev1sec5.html#iddle2671"> <span class="docEmphStrong">Audio Devices and Sound Themes icon (Control Panel)</span></A><br> <A class="v2" href="ch09lev1sec6.html#iddle2684"> <span class="docEmphStrong">authoring (DVD), Windows DVD Maker</span></A><br> <A class="v2" href="ch07lev1sec5.html#iddle2218"> <span class="docEmphStrong">AutoComplete option (Tablet PC Input Panel)</span></A><br> <A class="v2" href="ch07lev1sec5.html#iddle2202"> <span class="docEmphStrong">Automatic Learning option (Handwriting tab)</span></A><br> <A class="v2" href="ch06lev1sec4.html#iddle1904"> <span class="docEmphStrong">Automatic Scanning and Removal section (Options page)</span></A><br> <A class="v2" href="ch09.html#iddle2403"> <span class="docEmphStrong">AutoPlay window</span></A><br> <A class="v2" href="ch07lev1sec5a.html#iddle2175"> <span class="docEmphStrong">auxiliary displays (Windows SideShow Control Panel)</span></A><br><span class="docEmphStrong">Avalon</span>
[See <a class="docLink" href="W.html#iddle1127"><span class="docEmphStrong">WPF (Windows Presentation Foundation)</span></a>.]<br><br></td></tr></table>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=SYMBOL.html><img src="images/prev.gif" width="60" height="17" border="0" align="absmiddle" alt="Previous Page"></a>
<td align="right"><div STYLE="MARGIN-LEFT: 0.15in;">
<a href=B.html><img src="images/next.gif" width="60" height="17" border="0" align="absmiddle" alt="Next Page"></a>
</div></td></tr></table>
</body></html>
جالبه که بگم
من دیروز بدون مشکل داشتم کار میکردم
و حدود 800 صفحه رو با همین برنامه که نوشتم ریختم تو دیتا بیس و جالبه که یکی از همون صفحات همون کد اولی هست که گفتم الان ارور میگیره
ولی اون موقع ارور نمیگرفت
 

shervin

ASP.net
کاربر قدیمی پرشین تولز
تاریخ عضویت
26 ژوئن 2005
نوشته‌ها
6,353
لایک‌ها
261
سن
38
محل سکونت
تهران
جالبه که کد اولی که نمییزه کوتاهتر از کد دومی هست
یه سوال
فکر میکنی اگه بتونم همه ی این چند 100 هزار صفحه شایدم میلیون صفحه رو آپلود کنم بهتر باشه هم از نظر سرعت و هم از نظر پرفورمنس یا اینکه همرو بریزم تو دیتا بیس؟
 

Y2K

Registered User
تاریخ عضویت
20 فوریه 2006
نوشته‌ها
656
لایک‌ها
1
محل سکونت
Location
خوب
من دقیقا اومدم همون دوتایی رو که نوشتی اینسرت و آپدیت کردم روی دیتابیس خودم مشکلی نداشت - البته نوعی که من انتخاب کردم از نوع ntext است و طول 16.
1- فیلد دیگه ای رو باهاش اینسرت یا آپدیت نمیکنی؟ سایز و نوع اون فیلدها درست هستن؟
 

shervin

ASP.net
کاربر قدیمی پرشین تولز
تاریخ عضویت
26 ژوئن 2005
نوشته‌ها
6,353
لایک‌ها
261
سن
38
محل سکونت
تهران
چرا فیلد های دیگه ای هم هستن ولی مشکل از اونا نیست
چون واسه امتحان فقط با همین یکی امتحان کردم مشکل سر جاش بود
 

balabala

کاربر قدیمی پرشین تولز
کاربر قدیمی پرشین تولز
تاریخ عضویت
22 می 2005
نوشته‌ها
8,362
لایک‌ها
5,745
سن
41
محل سکونت
یه خورده اونورتر
یا همونطور که y2k گفت مشکل سایز فیلدته، یا اینکه متن رو html decode ( فانکشنش دقیق یادم نیست) نمیکنی و مثلا به " که میرسه اشتباه میکنه.
 

shervin

ASP.net
کاربر قدیمی پرشین تولز
تاریخ عضویت
26 ژوئن 2005
نوشته‌ها
6,353
لایک‌ها
261
سن
38
محل سکونت
تهران
راه حلو پیدا کردم
به قدری به نظر مسخره میاد که نگو
هر وقت انتر پرایز منجر باز باشه ارور میده و هر وقت بسته باشه بدون مشکل کار میکنه
الان کلی فایل کانورت کردم بدون مشکل ولی به محض باز شدن انترپرایز ارور میده
 

balabala

کاربر قدیمی پرشین تولز
کاربر قدیمی پرشین تولز
تاریخ عضویت
22 می 2005
نوشته‌ها
8,362
لایک‌ها
5,745
سن
41
محل سکونت
یه خورده اونورتر
جلل خالق
wha%5B1%5D.gif
 
بالا