mysql: measuring textlength in blob

[saloon12yrd]

Hey folx,

is there a working way to measure the actual length of a text stored in a TEXT/BLOB field with database functions only?

I'm asking because the result from the SQL LENGTH() function is correct only for stringlengths below 1¹⁶ + 1 = 65537 bytes. (Who's responsible for this crap?!).

BTW: Plz don't nag about me using MySQL, the customer want's it sigh.

Oh, mysql version 3.23.43 in use.

Thanks in advance.

Dominique

[flipis]

I just tried, made a table and filled it with almost 500,000 characters in a blob. This is the result:

SELECT LENGTH(blobber) FROM blobs

Result:

LENGTH(blobber)
11
314392

Server: 3.23.49-nt

Dunno about yor server. You can try CHARACTER_LENGHT, or CHAR_LENGHT

fLIPIS