Total size of serialized data

hi
I need to calculate the size of serialized data in db for my quota
operation.How can I find it ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gezerpunta wrote:
> I need to calculate the size of serialized data in db for my quota
> operation.How can I find it ?

Assuming "size" = "disk space" and "serialized data" = "output of
serialize()" function and you already have serialized that data, use
LENGTH()
<http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length>

- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org> Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGWdi2qTO+fYacSNoRArRUAJ9cZ3qTOrA8Zd9ZNyMkcC cMjva9UQCghVV6
LkWGhg8OQas6SclKKgbdwLs=
=iGau
-----END PGP SIGNATURE-----

my datas are binary files so I uses large object in postgresql.


On 27 Mayýs, 22:15, "Edward Z. Yang" <edwardzy...@thewritingpot.com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> gezerpunta wrote:
> > I need to calculate the size of serialized data in db for my quota
> > operation.How can I find it ?
>
> Assuming "size" = "disk space" and "serialized data" = "output of
> serialize()" function and you already have serialized that data, use
> LENGTH()
> <http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function...>
>
> - --
> Edward Z. Yang GnuPG: 0x869C48DA
> HTML Purifier <htmlpurifier.org> Anti-XSS HTML Filter
> [[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org
>
> iD8DBQFGWdi2qTO+fYacSNoRArRUAJ9cZ3qTOrA8Zd9ZNyMkcC cMjva9UQCghVV6
> LkWGhg8OQas6SclKKgbdwLs=
> =iGau
> -----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gezerpunta wrote:
> my datas are binary files so I uses large object in postgresql.

octet_length()
<http://www.postgresql.org/docs/8.2/interactive/functions-binarystring.html>

Seriously, please RTFM.
- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org> Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGWeUmqTO+fYacSNoRAin7AJ4qrnxXJteAt3ikNp3iz1 HXT4amZACfa4o7
5ENIt1T098k7hEK2/hxv41s=
=k3Ep
-----END PGP SIGNATURE-----