|
|
|
Author |
Message |
DarkSoul
|
Posted: 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
|
Posted: 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
|
Posted: 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.)
|
|
|
|
|
|
|