Which fields should I use?

[Greg Olson-Hyde]

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?

Cheers

Greg Olson-Hyde
Sydney Australia

2.8 GHz Quad-Core Mac Pro
Mac OS X 10.5.8
RB 2009 r2.1 Pro
Valentina Studio Pro 4.2 trial