Question on the length of VarChar?

[Ruslan Zasukhin]

On 2/7/05 2:39 PM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

> Hi,
> 
> At the moment I have an encoded MacRoman database with, for the example,
> VarChar (8) which are enough for what I make.

Btw, not good idea.
For such small length better to use String[8]

> Let us suppose that soon I like to be able to put in it 'Вячеслав' ou
> 'Éçäôñùvà'. 
> It will be necessary for me to change the encodage (OK) and my VarChar
> (8) will be insufficient.
> 
> My question: 
> If, to record the same data, I define at the moment my varchar ( 256 )
> instead of varchar (8)...

Note, the best minimal length for VarChar field is 504 (for 1.x)

> Is the size of the data base going to get grow as a consequence?

No.

> Will there be a loss of speed in the search ?

no

> I work on Mac with RB 5.54 and Valentina 1.1

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------