Login Skip Navigation LinksWilsonORMapper > Forums Search
Demo Version Demo Version
Download and try for yourself a fully working demo version, including sample apps and documentation.  The only limitation is that the demo version only works inside the debugger.

PayPal Subscribe
Get It All for $50 USD:
WebPortal, ORMapper,
Source Code, All Updates
PayPal

User Login User Login
Log In
 
 
Reset Password

Wilson ORMapper Forums Wilson ORMapper Forums : General Support : varchar(8000)

Date Post
9/12/2006 8:16:04 PM
I have a table with a field of type varchar(8000). Unfortunately, I am
not able to store more then approx 3900 characters. This is the error I
get:

Disallowed implicit conversion from data type ntext to data type
varchar, table xxx column yyy  Use the CONVERT function to run this
query.

I have a feeling it might have something to do with Unicode/Multibyte
characters. Nevertheless, when I look at the values in SQL Server
Enterprise Manager and also copy them to WinWord I do not see that it
uses 16-bits/char (maybe it automatically handles this for display
purposes). In any case, how can I store 8000 characters in the field?

I am using Visual Studio 2005, C# and SQL Server 2000.

Thanks

9/12/2006 8:19:17 PM I just did with an existing app that I have and I didn't have any problem storing 8000 characters in a varchar(8000) field in MS Sql Server with my ORMapper.  I also did a look at the code just to be sure, and there's nothing that I can think of that would cause such a problem.  Can you send me a small app, along with an appropriate db script, to help me duplicate the issue that you are seeing?

Thanks, Paul Wilson
9/13/2006 6:24:36 AM

Paul,

Thanks for the reply. I have created a small example that shows the problem I am having. How can I send it to you as this form does not allow me to add attachments? Considering your comments I am probably doing something wrong (I'm a newbie).

Regards
9/13/2006 10:32:06 AM Sorry about that -- I need to make my email highly visible again as it used to be -- it is Paul@WilsonDotNet.com.

Thanks, Paul Wilson
3/18/2008 3:38:24 PM I ran into the same problem. I think this is related to the following issue:
You may receive an error message when you try to populate a SQL Server 2000 table with a Data Generation plan in Visual Studio 2005 Team Edition for Database Professionals: "System.Data.SqlClient.SqlError: Disallowed implicit conversion from data type nte

Note: I find it ironic that the title of this KB article is truncated on Microsoft's site, probably for being too long. :)

Regards,
Tim