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 <[EMAIL PROTECTED]> wrote:
For adjusting "max allowed packet" value, I need to know the maximum size of my blob fields. How can I get that? Dominik
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]