Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Re: How MaxDB stores varchar columns?
From: Marcin P (protectedpoczta.onet.pl)
Date: Mon Aug 22 2005 - 08:26:05 CDT
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)?
Uzytkownik "Alexei Novakov" <alexei_novakovyahoo.com> napisal w wiadomosci
> 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:
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb