Storing a great many fields in a database

Peter Haworth pete at
Mon Jul 16 15:50:18 EDT 2012

I retract "most other SQL dbs" nd replace it with "some other SQL dbs".
lcSQL Software <>

On Mon, Jul 16, 2012 at 12:05 PM, Ruslan Zasukhin <
ruslan_zasukhin at> wrote:

> 2) MOST databases, for example mySQL, Postgre and our Valentina DB have
>  a) STRING(N) -- fixed length string type.
>                          This one always eat 100 chars as you say
>  b) VarChar(N) -- variable length string ...
>                           This one eat given M chars + few helper bytes
>  c) TEXT -- this differ from VarChar in the way how string is stored.
>                   and  TEXT field is unlimited

More information about the Use-livecode mailing list