Converting fields from VarChar to String

[Ruslan Zasukhin]

On 1/26/12 3:16 PM, "Christer Olsson" <christer at ljusaideer.se> wrote:

Hi Christer,

> We're considering to change several VarChar fields to String fields to avoid
> some corruption troubles we are seeing with VarChar fields.

> Is it considered 
> safe to just convert the fields or should we make new String fields, copy the
> values from VarChar fields and then drop VarChar fields?

Best,
Christer



A) it should be safe if strings will not be truncated.

B) so question is what length of VarChar declared?
    what strings really there?

C) string with big N can take much more disk and be slower.
String field okay on my view for 5-20 chars only strings.


=======
May be there is sense wait few days yet to see 5.0 betas
And make tests with it.

We have add journaling with automatic rollback on open.
This  feature should eliminate any corruptions from crashes of app


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