VarCharField Limitation of 5000?

[Chuck Pelto]

Hi Ruslan,


On May 9, 2006, at 2:39 PM, Ruslan Zasukhin wrote:

> On 5/9/06 7:24 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
>> Doing a run on the app I created last year and am trying to move to
>> the new environment of V4RB2.
>>
>> Getting an odd VException while building the fields of the tables in
>> an API-way.
>>
>> Here's the call....
>>
>>    call tblSchedules.CreateVarCharField("schd_descript", 5000,
>> EVFlag.fIndexed) // description of the scheduled event
>>
>> If the integer for the size of the field is 5000, the VException
>> occurs. If it is 2000, there is no exception.
>>
>> What's causing this?
>
> VarChar has limit on 4K bytes => 2044 chars for UTF16.
>
> Check doc

Page 113 of the document I'm looking at, indicates 65K bytes.

What am I not understanding here?

What is the text storage item that will store 65K bytes? What is the  
call to establish it in an API-way database table?

Regards,

Chuck Pelto