v 2.3 -- VarChar limited to 2044 of UTF16 chars (4Kb page)

[Ruslan Zasukhin]

On 4/5/06 3:40 PM, "jda" <jda at his.com> wrote:

>>>  Would such databases be backwards compatible with 2.2?
>> 
>>    Valentina > 1022   -- NO
>> 
>>    VarChar[1022]      -- yes
>> 
> 
> Another question. If I do truncate to 1022, will all data be lost, or
> just anything longer than 1022?

longer

If do this you should do this using 2.2 engine
 
> And since 2.3 does support 2044 (right!!!!???!??), can I do this with 2.3:
> 
> convert [2000] to [2044]

Problem is that 2.3 fails on DB made by 2.2 with VarChar[2000]

Deal is that 
    
    2.2 use for VarChar[2000]           8K page
    2.3 use for VarChar[2000]           4K page

You see?

2.3 simply cannot read database made by 2.2
 

> and retain the data in those fields, and have them work with 2.3?
> 
> If so, what happens if I try to open them with 2.2?

2.3 database with VarChar[1022]  -- no problems in 2.2

2.3 database with VarChar[2044]  -- will not work in 2.2



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]