From: Christoph Weser (Christoph.WeserSeeTec.de)
Date: Mon Mar 22 2004 - 04:29:07 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello!

Hope this question isn't answered 1000-times, but I haven't found anything
in the list archive.

I create the test table:

create table testtable (
       test varchar(100) not null,
)

The question:
Will this 100 Byte be allocated (or something like that) before Usage, or is
it really complete dynamical, like the name suggests?
In the theoretical case, that in every row, only the first 10 bytes will be
used, would there be any difference using:

        test varchar(100) not null,

and
        test varchar(1000) not null,

concerning memory consumption and stuff?

Thanx a lot!

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]