Which fields should I use?

[Ruslan Zasukhin]

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

Hi Greg,

 
> I am moving an SQLite db to Valentina. I would like to check that I am
> using the correct field types.
> 
> Foreign ID fields - 'Long'
> Fields to store values up to 9999 - 'Short'

> Fields to store text up to 20 words, requires 'Index By Words' - 'Text'

20 words can easy fit to VarChar(2044)

> Fields to store text of an unknown length (may be thousands of words),
> requires 'Index By Words' - 'Text'

Yes TEXT
 
> I have based the above on the information at:
> 
> http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vkernel:vfi
> eld:vfield

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