Data Import

[Ruslan Zasukhin]

On 8/2/04 7:27 PM, "Anna Kritselis" <akritselis at earthlink.net> wrote:

> Also - I'd like to go with the 4 files - structure, index, data, blob.  I will
> encrypt the structure, and then encrypt certain fields within certain tables.

ok

> I'm thinking that I will stay with the traditional relational approach to keep
> my SQL commands standard - most of my queries involve 3-4 tables.

ok

> I'm not sure I fully understand the ObjectPtr stuff yet - I'm sure I'll learn
> as I go along.  

ok

> When I have a required text field, like first and last name, should I
> use string(25) and string (50)?

I recommend use in both cases VarChar(504)

> The documentation says to use either string
> or varchar.  If I have a text field that may or may not have data, should I
> use VarChar?  I also have a table with comment fields that could have two
> sentences or 4-5K woth of text - I'm thinking I use text data type there.

Yes, use Text[256] or may be Text[512]

> Any thoughts/suggestions would be greatly appreciated -

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------