[V4MD] member().media into varbinary

[Ruslan Zasukhin]

on 11/20/03 11:20 PM, Scott Runkel at srunkel at hypix.com wrote:

Hi Scott,

> Please excuse my lack of knowledge...
> 
> I want to put member().media of many #text members into Valentina. It appears
> that this could be put into a BLOB or a varbinary or a fixedbinary. I think
> varbinary makes the most sense, since I don't need the size that BLOB allows.
> But I'm not sure...

Depend on your data.

Assume you make Varbinary[2048]

Can you be sure that all your data fit this size?
If yes, then go ahead.

You will make 

    Varstring[2048]     -- for text
    Varbinary[2048]     -- for style

BTW, I am not sure if style take the same size as its .TEXT.
Anybody know ?

Or you need simply test this on Varchar[100]


> The other major question is, for varbinary, what to set as the MaxLength. The
> doc states "For FixedBinary and VarBinary field you must specify Param1 as
> MaxLength." What if I choose a length that's too low -- will some of my
> members
> get cut off or corrupted?

They will be stored truncated,
So yes, on read back you get wrong data

> If I choose a length that's way too high -- will my
> database be bloated?

With VarBinary -- NO

> The VKernal reference has almost no information on varbinary, except that it
> is "binary data of variable length" from 1..65535 bytes.

Yes. That is enough.

All rest as in VarChar field.

Again, all depend what data you want to store

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