I have tried it but it failed to give me that size. It only works when the
content is a CHAR or VARCHAR. It just returns the number of characters, not
the disk size.
----- Original Message -----
From: "Egor Egorov" <egor.egorov@stripped>
Sent: Thursday, January 08, 2004 18:06
Subject: Re: Knowing the real size of a column
> "Director General: NEFACOMP" <dg@stripped> wrote:
> > Does anyone know of a simple way of knowing the real size of a column.
> > Currently I am interested in knowing the size of data stored in a BLOB
> > I have tried BIT_LENGTH() but this one does not seem to return the real
> Would you want to use LENGTH() function?
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Egor Egorov
> / /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1