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
