Alexei Novakov wrote: > > Hi all, > > I found the information that SAPDB/MaxDB core doesn't > distinguish between char and varchar types. Does it > mean that varchar length is not really variable when > it's stored in the database? So, for example, if I > have varchar(32) field and insert string with length 2 > how many bytes will be allocated in the physical > storage to sore this value? >
I have to add: if we are talking about version >= 7.6, then the installation parameter COLUMNCOMPRESSION has to be taken into account. If set to YES (default), even char-columns/numeric columns (except for the (n-1) first primary key columns) of newly created tables will be stored with variable length. With the next version even altered old tables (at least if re-structuring/restoring is needed anyway) will be changed accordingly, meaning stored with more variable length column than explicitly specified. Elke SAP Labs Berlin > Thank you. > > Alexei Novakov > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
