17 Feb
2010
17 Feb
'10
9:01 a.m.
Hi Sjoerd,
I noticed OCTET_LENGTH(blob_column) does not work.
According to the SQL standard, OCTET_LENGTH() is for both both character strings and binary strings.
I found that this workaround:
SELECT LENGTH(CAST(intag as TEXT))
seems to return what I need.
But it would be nice to make OCTET_LENGTH() work in the future :)
Do you have a feature request database? I can file a new request.
Thanks.