try something like this...
(raw SQL)

SELECT id, OCTET_LENGTH(blob_col) AS blob_size_bytes FROM my_table;

> Il giorno 24 giu 2025, alle ore 21:27, ocs--- via Webobjects-dev 
> <webobjects-dev@lists.apple.com> ha scritto:
> 
> Hi there,
> 
> the subject says it all. I've got a FS which reads in some columns set up 
> through setRawRowKeyPaths. The entity contains also a BLOB column which can 
> be rather big. Is there a trick to get its size only in the result 
> dictionaries, without actually fetching the data?
> 
> If db-specific, with FrontBase.
> 
> Thanks a lot!
> OC
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/amedeomantica%40me.com
> 
> This email sent to amedeomant...@me.com

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to