List:General Discussion« Previous MessageNext Message »
From:Gabriel PREDA Date:September 14 2006 7:52am
Subject:Re: How to get size of biggest blob (for max_allowed_packet)?
View as plain text  
SELECT LENGTH(`CnText`), CHAR_LENGTH(`CnText`), BIT_LENGTH(`CnText`)
   FROM `Translations`

Where:
 - LENGTH or OCTET_LENGTH - length in bytes
 - CHAR_LENGTH or CHARACTER_LENGTH - length of the string in characters
 - BIT_LENGTH - it's LENGTH * 8

You will see a difference betwen LENGTH and CHAR_LENGTH only if you
use multi-byte strings ! ... I use CN and others...

So... try:
SELECT MAX(LENGTH(`CnText`)) FROM `Translations`

-- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer

On 9/14/06, Dominik Klein <dk@stripped> wrote:
> For adjusting "max allowed packet" value, I need to know the maximum
> size of my blob fields.
>
> How can I get that?
>
> Dominik
Thread
How to get size of biggest blob (for max_allowed_packet)?Dominik Klein14 Sep
  • Re: How to get size of biggest blob (for max_allowed_packet)?Gabriel PREDA14 Sep