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.
Thanks Emery ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 18:06 Subject: Re: Knowing the real size of a column > "Director General: NEFACOMP" <[EMAIL PROTECTED]> 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 column. > > I have tried BIT_LENGTH() but this one does not seem to return the real size. > > 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]