Posted by Edward Z. Yang on 05/27/07 19:15

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

• Next in forum: Re: Total size of serialized data
• Prev in forum: Re: Working with Timezones and DST
• Thread view: Re: Total size of serialized data

[Reply to this message]