Posted by gezerpunta on 05/27/07 19:35

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+fYacSNoRArRUAJ9cZ3qTOrA8Zd9ZNyMkcCcMjva9UQCghVV6
> LkWGhg8OQas6SclKKgbdwLs=
> =iGau
> -----END PGP SIGNATURE-----

[Back to original message]