Re: [sqlite] group_concat for binary?

ite.org> Subject: Re: [sqlite] group_concat for binary? > Why do you think a BLOB stores text more efficiently? Do you compress it? > > He Shiming wrote: >> Hi, >> >> I would like to know if there is some workaround to use group_concat on >> binary columns

Re: [sqlite] group_concat for binary?

Why do you think a BLOB stores text more efficiently? Do you compress it? He Shiming wrote: > Hi, > > I would like to know if there is some workaround to use group_concat on > binary columns. > > For performance consideration, I need to query two tables and accomplish > data retrieval in a

[sqlite] group_concat for binary?

Hi, I would like to know if there is some workaround to use group_concat on binary columns. For performance consideration, I need to query two tables and accomplish data retrieval in a single SELECT. There is this BLOB column, originally designed as BLOB rather than text so that the storage