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

[Ruslan Zasukhin]

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

>> * PageFile store into disk file the size of page.
>> 
>>     your VarChar[2000]  in 2.2 have use 8K page.
>>     your database remember this
>> 
>> * now when 2.3 read this it get wrong size - 8K instead of 4K.
>>     and even worse -- your data really is located on 8K page.
>>     and 2.3 do not have way now to read such pages.
>> 
>> 
>> 
>> 2) We can try implement own algorithm of conversion
>>     but we can do this only for case 1a)
>> 
>>     for case 1b) we cannot do this automatically
>>     because you need adjust your sources to use Text instead VarChar.
>> 
> 
> Hi Ruslan.
> 
> It seems to me that (2) would be best. Meaning, an algorithm to
> automatically convert 2.2 (8K pages) varchar fields to 2.3 (4K
> pages). In my case, it is very unlikely that data is stored in the
> pages 5-8 (I used a size of 2044 because you told us many times it
> was the optimal size in Valentina 2.x).

I did say this ??? 
    I believe in docs pointed 1022
    Valentina Studio also offer 1022
 
> Would such databases be backwards compatible with 2.2?

   Valentina > 1022   -- NO

   VarChar[1022]      -- yes



-- 
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]