From: Marcin P (protectedpoczta.onet.pl)
Date: Mon Aug 22 2005 - 08:26:05 CDT

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

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" <alexei_novakovyahoo.com> napisal w wiadomosci
news:20050822131811.214.qmailweb88112.mail.re2.yahoo.com...
> 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/maxdb?unsub=gcdm-maxdbm.gmane.org
>
>

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

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