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