VARCHAR (10000) ??  
Author Message
DarkSoul





PostPosted: Thu Nov 18 21:33:29 CST 2004 Top

SQL Server Developer >> VARCHAR (10000) ??

Hi:

I'm a newby!

I have an app that requires a varchar (10000) field. The maximum "legal"
size for these fields is 8000. Is there a way to increase the size of the
fields - if not then I will have to make two 8000 fields and concatenate
them.

Or - is there another data type that will work?

Any help would be GREATLY appreciated!

Thanks,

Fred

SQL Server171  
 
 
David





PostPosted: Thu Nov 18 21:33:29 CST 2004 Top

SQL Server Developer >> VARCHAR (10000) ?? use text or ntext data type




> Hi:
>
> I'm a newby!
>
> I have an app that requires a varchar (10000) field. The maximum "legal"
> size for these fields is 8000. Is there a way to increase the size of the
> fields - if not then I will have to make two 8000 fields and concatenate
> them.
>
> Or - is there another data type that will work?
>
> Any help would be GREATLY appreciated!
>
> Thanks,
>
> Fred
>
>
>
>


 
 
Aaron





PostPosted: Thu Nov 18 22:14:26 CST 2004 Top

SQL Server Developer >> VARCHAR (10000) ?? > I have an app that requires a varchar (10000) field. The maximum "legal"
> size for these fields is 8000. Is there a way to increase the size of the
> fields - if not then I will have to make two 8000 fields and concatenate
> them.

No, you won't be able to do that either, because you can only store a
maximum of 8,060 bytes per row. You can create a table with more allowed
bytes, and you will only get a warning. But if you try to exceed 8,060
bytes, the INSERT/UPDATE will fail.

This was discussed at length earlier today, right here in this group. Have
a look at the thread, "Inserting big values"

--
http://www.aspfaq.com/
(Reverse address to reply.)