List:General Discussion« Previous MessageNext Message »
From:Director General: NEFACOMP Date:January 9 2004 10:33am
Subject:Re: Knowing the real size of a column
View as plain text  
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" <egor.egorov@stripped>
To: <mysql@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
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
>  / /|_/ / // /\ \/ /_/ / /__   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
>
>
>


Thread
Knowing the real size of a columnDirector General: NEFACOMP8 Jan
  • Re: Knowing the real size of a columnEgor Egorov8 Jan
  • Re: Knowing the real size of a columnrobert_rowe8 Jan
    • Re: Knowing the real size of a columnDirector General: NEFACOMP9 Jan
  • Re: Knowing the real size of a columnDirector General: NEFACOMP9 Jan
    • Re: Knowing the real size of a columnDan Nelson9 Jan