Re: Knowing the real size of a column

2004-01-09 Thread Dan Nelson
In the last episode (Jan 09), Director General: NEFACOMP said: > 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. Isn't that the same thing? LENGTH() would really be better, si

Re: Knowing the real size of a column

2004-01-09 Thread Director General: NEFACOMP
: "robert_rowe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 19:29 Subject: Re: Knowing the real size of a column > > If you are using ADO then the field object has an actualsize property that should give you your value. > > --

Re: Knowing the real size of a column

2004-01-09 Thread Director General: NEFACOMP
ent: 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 s

Re: Knowing the real size of a column

2004-01-08 Thread robert_rowe
If you are using ADO then the field object has an actualsize property that should give you your value. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Knowing the real size of a column

2004-01-08 Thread Egor Egorov
"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 ret

Knowing the real size of a column

2004-01-07 Thread Director General: NEFACOMP
Hi group, 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. Thanks, __ NZEYIMANA