<div>
Hi, please make sure that if you are using stored procedure, and the variable you are using for storing your description is say for example varchar2(1000) &nbsp;and in the procedure variable declaration, you might have forgotten to write the number and might have written varchar2 only. If its the case, make it 1000.
</div>


<div>
If your country use two byte character like Korea, Chinese, Japan, be aware of two byte character.<br />
<br />
nvarchar recognize all characters as two byte, but varchar is not.<br />
<br />
Let's say if A is two byte char, you can see different result as below.<br />
<br />
And Javascript's length property is varied by browser type and version for two byte character.<br />
Because of this, I created and using custom Javascript function for two byte character.<br />

<pre><code class="code-1 nolinks" id="code-274505"><span>declare @s varchar(1)</span>
<span>declare @s2 nvarchar(1)</span>
<span> </span>
<span>set @s = 'A'</span>
<span>set @s2 = 'A'</span>
<span> </span>
<span>print @s --space</span>
<span>print @s2 --A</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi I have a textbox callled description , <br />
its corresponding database column is description whoxe max is 1000<br />
<br />
On an insert, The database is throwing truncation error<br />
I have a javascript that doesnt allow the user to enter more than 1000 chars in textbox<br />
Even though this error happens?<br />
<br />
What shoudl I do
</div>
</div>


Hi I have a textbox callled description , 
its corresponding database column is description whoxe max is 1000

On an insert, The database is throwing truncation error
I have a javascript that doesnt allow the user to enter more than 1000 chars in textbox
Even though this error happens?

What shoudl I do

String Truncate C# , Database Truncate Error

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications