Which fields should I use?

[Ruslan Zasukhin]

On 8/24/09 9:38 AM, "Greg Olson-Hyde" <greg at hawkmount.com> wrote:

> 
> On 24/08/2009, at 4:10 PM, Ruslan Zasukhin wrote:
> 
>>> Fields to store text up to 20 words, requires 'Index By Words' -
>>> 'Text'
>> 
>> 20 words can easy fit to VarChar(2044)
> 
> Hi Ruslan,
> 
> Thanks for your reply.
> 
> I have looked at the page on fields and can't work out the advantage
> of using VarChar over Text - could you explain it please?

Have you see this page

http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vkernel:v
field:string_fields

Here said:

>For strings with a length 20..1024 bytes, it is better to use VarChar or String
fields.


VarChar is faster of TEXT



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