Alexei Novakov wrote: > > Hi all, > > I found the information that SAPDB/MaxDB core doesn't > distinguish between char and varchar types.
Where did you find this? In which context? > 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? > VARCHAR is stored with variable length. One exception: the first (n-1) primary key columns are stored with fixed length no matter if specified as char or varchar. Varchar (32) filled with 2 user-value-bytes will need 4 bytes (1 byte length, 1 byte info if it is the NULL-Value or not, the 2 bytes given by the user) But: char is not always stored with fixed length. If the internal length exceeds 31 bytes (char (31) ascii resp. char (16) Unicode), the value is stored with variable length, no matter if given as char or varchar (except for the first (n-1) primary key columns as written above). 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]
