Need an unlimited length char field

[Nishi Narula]

Hi,

If I want to make a field of characters to be unlimited length(or maybe 2k for example), what datatype should I use?
Char, varchar and text have a max. limit of 255...

Will appreciate any suggestions.

Thanks,
Nishi

[Ray Miao]

On 12/7/98 2:00:16 PM, Nishi Narula wrote:
> Hi,

If I want to make a field of characters to be unlimited length(or
> maybe 2k for example), what datatype should I use?
Char, varchar and text
> have a max. limit of 255...

Will appreciate any
> suggestions.

Thanks,
Nishi

Unfortunately you can't do that since SQL server has limit for row size.

[JP]

Hi Nishi!
U CAN USE TEXT FIELD DATATYPE TO ENTER AS MANY CHARS!
But with following limitations:
1)u will NOT be able to have any queries on that field,
2)cannot have 'Distinct' clause if u have the field in select list.
I think what made u think that it stores only 255 chars in the fact that in Ent Mgr, it doesnt show charactes beyond 255 when u run select on Text type field, but the data is there. I also got lil confused with it. But yes it can store as many chars...u know its like memo field, used to be in Foxpro(if u know)
Cheers
-JP

On 12/7/98 2:56:06 PM, Ray Miao wrote:
> On 12/7/98 2:00:16 PM, Nishi Narula wrote:
> Hi,

If I want to make a
> field of characters to be unlimited length(or
> maybe 2k for example),
> what datatype should I use?
Char, varchar and text
> have a max. limit
> of 255...

Will appreciate any
>
> suggestions.

Thanks,
Nishi

Unfortunately you can't do that since SQL server has limit for row size.

[Vijay V M]

Hello Nishi,

As Mr. JP says it is possible to use TEXT Field, but my suggestion is better donn't use text field. Because it uses 2k of space to store one text field.
refer the Help before using Text field.

It will reduce the performanance a lot.

So what i feel is you better design database such that the field will not cross 255 char. For Ex..If you want to store 500 char, use 2 varchar fields of 255 each. This is just an example.

Good luck
__Vijay VM




On 12/9/98 12:55:04 AM, JP wrote:
> Hi Nishi!
U CAN USE TEXT FIELD DATATYPE TO ENTER AS MANY CHARS!
But with
> following limitations:
1)u will NOT be able to have any queries on that
> field,
2)cannot have 'Distinct' clause if u have the field in
> select list.
I think what made u think that it stores only 255 chars in
> the fact that in Ent Mgr, it doesnt show charactes beyond 255 when u run
> select on Text type field, but the data is there. I also got lil confused
> with it. But yes it can store as many chars...u know its like memo field,
> used to be in Foxpro(if u know)
Cheers
-JP

On 12/7/98 2:56:06 PM, Ray
> Miao wrote:
> On 12/7/98 2:00:16 PM, Nishi Narula wrote:
> Hi,

If I
> want to make a
> field of characters to be unlimited length(or
> maybe
> 2k for example),
> what datatype should I use?
Char, varchar and text
>
> have a max. limit
> of 255...

Will appreciate any
>
>
> suggestions.

Thanks,
Nishi

Unfortunately you can't do that since
> SQL server has limit for row size.

[Nishi Narula]

On 12/9/98 1:34:14 AM, Vijay V M wrote:
> Hello Nishi,

As Mr. JP says it is possible to use TEXT Field, but my
> suggestion is better donn't use text field. Because it uses 2k of space
> to store one text field.
refer the Help before using Text field.

It
> will reduce the performanance a lot.

So what i feel is you better design
> database such that the field will not cross 255 char. For Ex..If you want
> to store 500 char, use 2 varchar fields of 255 each. This is just an
> example.

Good luck
__Vijay VM




On 12/9/98 12:55:04 AM, JP
> wrote:
> Hi Nishi!
U CAN USE TEXT FIELD DATATYPE TO ENTER AS MANY
> CHARS!
But with
> following limitations:
1)u will NOT be able to have
> any queries on that
> field,
2)cannot have 'Distinct' clause if
> u have the field in
> select list.
I think what made u think that it
> stores only 255 chars in
> the fact that in Ent Mgr, it doesnt show
> charactes beyond 255 when u run
> select on Text type field, but the data
> is there. I also got lil confused
> with it. But yes it can store as many
> chars...u know its like memo field,
> used to be in Foxpro(if u
> know)
Cheers
-JP

On 12/7/98 2:56:06 PM, Ray
> Miao wrote:
> On
> 12/7/98 2:00:16 PM, Nishi Narula wrote:
> Hi,

If I
> want to make a
>
> field of characters to be unlimited length(or
> maybe
> 2k for
> example),
> what datatype should I use?
Char, varchar and text
>
>
> have a max. limit
> of 255...

Will appreciate any
>
>
>
> suggestions.

Thanks,
Nishi

Unfortunately you can't do that since
>
> SQL server has limit for row size.