Question on the length of VarChar?

Thierry Nauze ohmitou at wanadoo.fr
Mon Feb 7 17:05:04 CST 2005


Hi Ruslan, 

Thank you for this very fast answer.

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

I had taken 8 for the example with regard to 256.

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

If I understood, I have interest to be put, I have interest to be put the
minimal length of my varchar on 504... 


Regards

-- 
Thierry Nauze               Saint-Denis de la Réunion




More information about the Valentina mailing list