I can't say about the internal storage and the space occupied by the data. However, during my tests I noticed that ODBC Driver seems to pull the varchar(size) column values as they were char(size). It looks like there is no optimization for receiving and sending data. Can anyone confirm? Or is it only my false impression (which I hope)? Best regards,
Marcin Pytel -- Uzytkownik "Alexei Novakov" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > 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? > > 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]
