Storing a great many fields in a database

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


I retract "most other SQL dbs" nd replace it with "some other SQL dbs".
Pete
lcSQL Software <http://www.lcsql.com>



On Mon, Jul 16, 2012 at 12:05 PM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> 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