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

[Ruslan Zasukhin]

On 4/5/06 11:19 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> I see these ways 
> 
> 1) developer who have use in Valentina 2.2  VarChar fields longer of 1022
>     need ship intermediate version of own app, which will
>     CHANGE max length of all VarChar to 1022.
> 
>     if db.SchemaVersion = xxx then
> 
>         // 1a) for each VarChar with length > 1022 but < 2044
>         fld.maxlength = 1022
> 
>         // 1b) for each VarChar with length > 2044 do
>         fld.type = kTypeText
> 
>         db.SchemaVersin = db.SchemaVersion + 1
>     end    

I see another way.

For example Jon have now app built with 2.2.
I know that it can do XML dump.

So you can in ask people dump existing db using old version,
Then load XML using new version of your app based on 2.3.

This should work because VarChar[2000] is ok for 2.3
Just it uses 4K page for it instead of 8K


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